I have made this example database to show you my problem, I have 2 tables here:
1. "items" table that works like warehouse listing items in stock and has these fields:
ID autonumber
Example name TEXT
Sold Yes/No
2. "sales" table has these fields:
ID Autonumber
Example name created using Lookup in Design view
I created Query called "sales Query" that I use to enter data and my problem is I need only to be able to enter items that are not checked in "Items table".
In other words I need to be able to select in the query dropdown items currently in stock.
How to solve this the easy way? I tried using criteria "False" but dropdown still lists checked items WHY?
See my thread here to download attached database:
http://www.access-programmers.co.uk/forums/showthread.php?t=135530
1. "items" table that works like warehouse listing items in stock and has these fields:
ID autonumber
Example name TEXT
Sold Yes/No
2. "sales" table has these fields:
ID Autonumber
Example name created using Lookup in Design view
I created Query called "sales Query" that I use to enter data and my problem is I need only to be able to enter items that are not checked in "Items table".
In other words I need to be able to select in the query dropdown items currently in stock.
How to solve this the easy way? I tried using criteria "False" but dropdown still lists checked items WHY?
See my thread here to download attached database:
http://www.access-programmers.co.uk/forums/showthread.php?t=135530
