Lookup Table filtered

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database with two tables. Table "Bin" is used in my form as a drop
down box and updates table "Bin Assignment". There are about 2000 bins and
as their assigned I need them not to display as a choice after being
assigned.
Is there a way to filter based on what has already been assigned?
 
mccloud said:
I have a database with two tables. Table "Bin" is used in my form as a drop
down box and updates table "Bin Assignment". There are about 2000 bins and
as their assigned I need them not to display as a choice after being
assigned.
Is there a way to filter based on what has already been assigned?
Click to expand...


Set the combo box's RowSource query to something like:

SELECT Bin.BinNo
FROM Bin LEFT JOIN [Bin Assignment]
ON Bin.BinNo = [Bin Assignment].BinNum
WHERE [Bin Assignment].BinNum Is Null
 
Back
Top