Lookup in a Query

[Guest]

I have a (1)delivery note header table (2)delivery note details table (3)
customer suplier detail table linked only with ID to Delib header (4)
stocklist table Linked only with Id To deliv details. Now I want to write a
query to list the stock deliv to make a shipment how do I make a lookup to
the stock ID in the deliv note details table?
Hope I sound sane?

 

[John Vinson]

I have a (1)delivery note header table (2)delivery note details table (3)
customer suplier detail table linked only with ID to Delib header (4)
stocklist table Linked only with Id To deliv details. Now I want to write a
query to list the stock deliv to make a shipment how do I make a lookup to
the stock ID in the deliv note details table?
Hope I sound sane?

Well, Microsoft wasn't altogether sane when they created the Lookup
misfeature: see http://www.mvps.org/access/lookupfields.htm for a
critique.

Simply include the stocklist table in your query, joining to the
lookup field in your table. A Lookup Field isn't really either helpful
or necessary; all it does is conceal the actual contents of your table
(the ID) behind a combo box.

Do note that you should NOT be using either Table or Query datasheets
for data entry or viewing; use a Form instead. It's perfectly easy to
put combo boxes ("lookups") on a Form, whether or not you've defined a
table lookup.

John W. Vinson[MVP]