RE: Microsoft Access
now onto 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
|