Relationship model

[Moshe]

Hi Guys.

i have some Problem and i would like some help.
(i attach the file)

i bulid a tree model:

Product -> Model - > item

For Exmple for Product table i have ID 1 AND 2
ID 1 its Toyota when i click on details its take me to model and i want when i click model its take me to item but its take me to the specific item

Product -> Model - > item
Toyota - > corolla -> corolla 2018

the problem when i click Toyota - > corolla its show me corolla 2018 and yaris but yaris is different model.



thanks for help.

[ranman256]

you dont really need the autonumber for Product
Product itself can be the key. you are using מזהה, as the key, AND you have Product_ID in there too. Instead of these 3 fields, just use ProductName.
same with Model.
now, for ITEM, you should use and autonum....but again you are using 3 fields when 1 will do.

link tProduct.ProductName to tModel.ProductName
link tModel.ModelName to tItem.ModelName

note: If ModelName cannot be unique, then you will need to use an autonum for Model.ModelID.

[Moshe]

thanks ranman.

but If I leave it like that's what I can do to make it work ?
i try THIS BUT it not working
"[Product_ID]=" & [Product_ID] And "[Model_ID]=" & [Model_ID]

מזהה = ID.

[ranman256]

use the key, מזהה = ID.
the Keys are what links the fields together.
you are using extra fields you dont need.

[Moshe]

its not working

i change it to
"[Product_ID]=" & [Product_ID] And "[Model_ID]=" & [Model_ID]