NEW TO ACCESS!!! PLEASE HELP
Hi I am doing a form for work - somewhat like a PO.
I have 2 Tables
Suppliers(Table 1)
SupplierID SupplierName
BOE Boeh
INT Invet
PFZ Pfiz
Products(Table2)
ProductCode Product SupplierID
1234 Vitamins BOE
2345 Shots BOE
3456 Liquids INT
4567 Solids PFZ
On the form:
I have a Supplier Dropdown list where the clients would choose a supplier.
Once Client has chosen a Supplier, I would like all the products to show up in the list box so they can choose a product.
So if Boeh was choosen
1234 Vitamins BOE
2345 Shots BOE
would show in the listbox below.
How do I make the relationship between the two work?
Please HELP?

Hi I am doing a form for work - somewhat like a PO.
I have 2 Tables
Suppliers(Table 1)
SupplierID SupplierName
BOE Boeh
INT Invet
PFZ Pfiz
Products(Table2)
ProductCode Product SupplierID
1234 Vitamins BOE
2345 Shots BOE
3456 Liquids INT
4567 Solids PFZ
On the form:
I have a Supplier Dropdown list where the clients would choose a supplier.
Once Client has chosen a Supplier, I would like all the products to show up in the list box so they can choose a product.
So if Boeh was choosen
1234 Vitamins BOE
2345 Shots BOE
would show in the listbox below.
How do I make the relationship between the two work?
Please HELP?