Hi Folks,
Can anyone advice on the best strategy?
I have 2 tables (facilities and devices) that I want to connect with a linking table for a n to n relationship (following the approach in the tutorial). I have created a linking table to which I have added 2 databasejoin elements, one joined to the PK element of one table and one to the other table. I can add records to this list, linking records from the other 2 tables using the 2 dropdowns. However, I would like to be able to see some of the other fields from those tables to assure that I have selected the corrected items from those tables (the names may not be unique). What is the best approach to achieve this?
kind regards
Brian
Can anyone advice on the best strategy?
I have 2 tables (facilities and devices) that I want to connect with a linking table for a n to n relationship (following the approach in the tutorial). I have created a linking table to which I have added 2 databasejoin elements, one joined to the PK element of one table and one to the other table. I can add records to this list, linking records from the other 2 tables using the 2 dropdowns. However, I would like to be able to see some of the other fields from those tables to assure that I have selected the corrected items from those tables (the names may not be unique). What is the best approach to achieve this?
kind regards
Brian