Dear friends. I have 3 tables in the following format
TBL DIVISIONS
Division ID
Division Name
TBL_BUSINESS_UNITS
Division ID
Business Unit
TBL_PRODUCTS
Product ID
Product Name
Division
Business Unit
Each division may have several business units.
Each product may belong to one division.
I wish the user to select the product and define the division. Based on the division value the user should see the list of available business units in the product table (its very similar when user selects the US state and then selects the Cities which belongs to the current state only).
I can't understand what type of query I should develop for the TBL_PRODUCTS - Business Unit vlookup field.
Thanks for help.