Select * from carinfo where make {is unique}
How do I tell it not to make it an option in a dropdown box if there already is a record that matches.
Only 1 field will be the same between records and that is the make field.
Never mind again folks I figured this one out - always seems I figure these out after I have asked the question.