LookUP Help

[DaveyJ]

Hi Guys,




Having a problem with a look up table.

what i want to achieve is this...

a category table, with 3 categorys ,
each category has a list of products

what i want to do is when a category is selected, only the products of that particular category are visible to select.

Can anyone point me in the best way to achieve this?

[maximus]

This is a small example that I think may help you out.
I have a product table which has some products
Then I have a table Machine that processess these products.
Each product can be processed in specific machines.

Select a probuct and you will see the machines applicable to taht product is displayed in the list box.

I have used another Table to link the product and the machine caled product_machine_link


check it

[DaveyJ]

that helps alot, but how was it achieved?

[maximus]

Study the relationships. and the queries underlying the combobox and the list box. The third table basicall links the products and the Machine together. The List Box Rowsource is the Third Table product_machine_link. The Product_Machine_Link has Fields Product_id, Machine_id and entry_id. The criteria for product_id in the RowSource query of the list Box is [Forms]![Form9]![Combo0].

[DaveyJ]

i tried to look at the relationships , but they were not visible ?

where they locked or something?

[maximus]

press F11 that will allow you to look into the structure

[maximus]

main menubar - tools - relationships