Cascading combo boxes for subform (1 Viewer)

crislim1113

New member
Local time
Today, 21:24
Joined
Jan 27, 2021
Messages
19
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)
1611903039325.png

How can I do this?

Regards,
Cris
 

GinaWhipp

AWF VIP
Local time
Today, 09:24
Joined
Jun 21, 2011
Messages
5,901
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

New member
Local time
Today, 21:24
Joined
Jan 27, 2021
Messages
19
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)
1611909298950.png

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

GinaWhipp

AWF VIP
Local time
Today, 09:24
Joined
Jun 21, 2011
Messages
5,901
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

New member
Local time
Today, 21:24
Joined
Jan 27, 2021
Messages
19
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
 

Users who are viewing this thread

Top Bottom