AnsweredAssumed Answered

In need of assistance

Question asked by PaulStrasser on Jun 11, 2015
Latest reply on Jun 12, 2015 by philmodjunk


In need of assistance


Hi all,

I have made a car dealership database for school, and i have encountered a dilemma.

I realised that a car should not be able to be sold again if it has already been sold.

Has anyone got any suggestions on how i can prevent the car ID of cars that have already been sold from showing up when i input a new sale?

The tables in my database related to my situation are Cars (Car ID, Make, Model, Year etc.) and Sales (Sale ID, Car ID, Owner ID, Employee ID, Date etc.)