Hi, we have a relationship as shown below.
We are adding documents(files) in the order table and the files get saved in the documents table. We will have to show all the files uploaded in the orders table in both the child tables (accession and results) which are related to the parent order. What is the best way to achieve this?
Thanks,
Naveen
One way is to look up the Key field of rhe Orders Table (which might be [Record ID#] or some other field), down to the Results ta le (it's already on he Accesons table and then from there look up down to documents.
That will mean that have three possible sources for the key field of the orders table down in the documents table. Make a formula field which will calculate the value of the Key field from the directly Related Order, or if blank, then the Orders Key field from the Accessions, or the Record ID of the Order from the Results table.
Then make a Report Link field on the Orders table and set it up to match the Key field of Orders (on the left) with the calculated Key field (right side) on the Documents table.
or the record ID from the accession or the record ID of the order from the results.
