Lookup specific Tables!

  • Thread starter Thread starter Aymanh
  • Start date Start date
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!
 
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!
 
Again, are you storing "Kuhl Metals" or an ID that references "Kuhl Metals"
in your Order detail table?
 
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
 
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.
 
Back
Top