quote:
Originally posted by may73alliance
THANK YOU SO MUCH. my ict teacher couldnt even tell me how to do that
don't worry !! i kick my comptuin teachers arse when it comes to database's
anyway back to my problem ..........
is there anyway to make a drop down box (combo box) that will only show sources that haven't been used ???
what i have is 2 tables with details in (with an ID field in both tables) and then have a third table that matches the ID's in the first table to a certain ID in the second table. i only want to use the ID from each table once (so i have "No Duplicates" on) so is it possible to have the ID not appear in the drop down list once it has been used
/ 
