S
Skeletor
I am trying to modify a Access 2007 Northwind Db. I have added 3 tables -
"Sales Channel", "Suppliers" and "Categories" The tables are linked by a 1 to
Many relationship and also link to the original "Products" table
Sales Channel Suppliers Categories
Products
Sales Channel ID-1--00---Sales Channel ID Category
ID-1---00--Category ID
Channel Supplier ID-1------00--Supplier ID
Product ID
Supplier Category
Product
Supplier
Sales Channel
On the "Product Details" Form I have added 3 combo boxes with each ones
Control Source linked to the new fields in the "Products" table. I would like
to make a selection in the Sales Channel combo that would drill down the
"Supplier" combo, which would drill down the "Category" combo which would
finally filter the selection in the "Products" combo. All of the selections
would need to be stored in the "products table.
Could someone please advise what is to be placed in the Row Source and After
Update areas of each of the 4 combo boxes as, even with all the brilliant
advice given on this forum, I still manage to stuff it up royally.
thankyou,
Mike
"Sales Channel", "Suppliers" and "Categories" The tables are linked by a 1 to
Many relationship and also link to the original "Products" table
Sales Channel Suppliers Categories
Products
Sales Channel ID-1--00---Sales Channel ID Category
ID-1---00--Category ID
Channel Supplier ID-1------00--Supplier ID
Product ID
Supplier Category
Product
Supplier
Sales Channel
On the "Product Details" Form I have added 3 combo boxes with each ones
Control Source linked to the new fields in the "Products" table. I would like
to make a selection in the Sales Channel combo that would drill down the
"Supplier" combo, which would drill down the "Category" combo which would
finally filter the selection in the "Products" combo. All of the selections
would need to be stored in the "products table.
Could someone please advise what is to be placed in the Row Source and After
Update areas of each of the 4 combo boxes as, even with all the brilliant
advice given on this forum, I still manage to stuff it up royally.
thankyou,
Mike