Cascading combo boxes for subform

[crislim1113]

Hi, I would like to ask for assistance or any youtube link I can view..
In my project example. if I select the customer, BIG it will only show the BIG Products(Encircled in the picture)

How can I do this?

Regards,
Cris

 

[GinaWhipp]

Hmm, not sure I understand the question. What do you want it to show? Or are you saying you only want to see what Products that Customer has bought before?

 

[crislim1113]

Hmm, not sure I understand the question. What do you want it to show? Or are you saying you only want to see what Products that Customer has bought before?

Hi, this is the tableof products which each product belongs to a customer(CustomerID)

Example: BIG is customerID 2. in my subform when I input their order, it will only show their product.

 

[GinaWhipp]

The table with Products should not have the Customer ID. You should have a table tblCustomerProducts which will serve as a junction table between the two. tblProducts and tblCustomers.

 

[crislim1113]

The table with Products should not have the Customer ID. You should have a table tblCustomerProducts which will serve as a junction table between the two. tblProducts and tblCustomers.

ooooh i see . Thank you will try it

 

[GinaWhipp]

Will be here if you need additional help.