I didn't know how to describe this problem so i took a shot with multi join. I'll give you the scenario.
Table: Products
-> exists of many fields, 2 of them should be lead_plant and other_plant.
Table: Plants
-> contains: plant_id and plant_name
In the products table i'd like to make a join between the lead_plant and other_plant by the plant_id.
How do I do this in the relationship window and what do I do best when using querys? Because in the end, I'd like to see the bound plant_name and not the plant_id when I create a report.
Greetz,
Joeri
Table: Products
-> exists of many fields, 2 of them should be lead_plant and other_plant.
Table: Plants
-> contains: plant_id and plant_name
In the products table i'd like to make a join between the lead_plant and other_plant by the plant_id.
How do I do this in the relationship window and what do I do best when using querys? Because in the end, I'd like to see the bound plant_name and not the plant_id when I create a report.
Greetz,
Joeri