Hello, I am trying to alter a form (OrderDetail) from the Northwind Traders Database. Basically I have made a Detailed Category field and would like to "drill-down" the list of products based on this detailed category
So the user would select a Detailed Category, then select a product with that detailed category. I have quite a few products and this would make input much faster/easier/less mistakes. I set the row source as a list of products, with the criteria that the DetailCat=[Forms]![orderdetail]![sbfOrderDetails].[Form]![cboDetailCat]
I keep getting the error the current field must match the join key. I've made a simplified version of my database and uploaded it if anybody would be kind enough to take a look.
So the user would select a Detailed Category, then select a product with that detailed category. I have quite a few products and this would make input much faster/easier/less mistakes. I set the row source as a list of products, with the criteria that the DetailCat=[Forms]![orderdetail]![sbfOrderDetails].[Form]![cboDetailCat]
I keep getting the error the current field must match the join key. I've made a simplified version of my database and uploaded it if anybody would be kind enough to take a look.
"Drill Down" Multiple Field selection
0 commentaires:
Enregistrer un commentaire