V
Valerie Wong
In my database there are x projects and each project has different products
e.g.
Project Product
A 1,2,3,4,5
B 6,7,8
C 9,10,3,5
D 2,4,6,8
In a new form, there are two combo boxes, the first one is a combo box based
on the Project table, so user can choose which Project they want; the 2nd one
is a combo box that I want to base on the Products, but only the products
that are in the project selected in the first box. For example, if user chose
project A, the product combo box should only show a list of products, 1,2,3,4
and 5. How could I achieve this?
Regards,
Valerie
e.g.
Project Product
A 1,2,3,4,5
B 6,7,8
C 9,10,3,5
D 2,4,6,8
In a new form, there are two combo boxes, the first one is a combo box based
on the Project table, so user can choose which Project they want; the 2nd one
is a combo box that I want to base on the Products, but only the products
that are in the project selected in the first box. For example, if user chose
project A, the product combo box should only show a list of products, 1,2,3,4
and 5. How could I achieve this?
Regards,
Valerie