In need of assistance
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.)