Lookup specific Tables!

A

Aymanh

Duane:

I meant by Specific supplier is: lets suppose Kuhl metals sells to me the
Aluminum, and Wrap-N-Pack sells to me the Bubble wrap.

so when I go to the order detail to order aluminum from Kuhl metals I click
the arrow "through lookup" and I choose Kuhl, then when I reach the field
named product ID I click the lookup arrow and products from Wrap-N-Pack show
up also! how can I "either in the form or data sheet" only create a drop
list or lookup that only shows the products for let's say Kuhl metal not
everything!

Many thanks!
 
A

Aymanh

Kuhl metals is a supplier and stored in a reference table called
tblSupplier"as texts books refer to it". Order detail is a table where it
takes all the order information from the following tables:
tblSuppliers - for supplier infomration
tblProduct list - for product descrtiption
tblUOM - unit of measure lb., foot, etc.
tblEmployees -
tblDepartments -
PO# for purchase order numbers

I'll look also into the website your've sent!
 
D

Duane Hookom

Again, are you storing "Kuhl Metals" or an ID that references "Kuhl Metals"
in your Order detail table?
 
A

Aymanh

Duane:

I have two books for Access:

Access Bible 2000
Access Inside Out 2002

What good books do you recommend for fast growing users? and has all detail?

Regards,
Ayman
 
D

Duane Hookom

I have the Inside Out 2003 book and have found it very comprehensive. The
site I sent you to has an example of cascading combo boxes.
 
Top