One Column with Multiple Link References

[#1]

Hello,

I have a file with a batch number and quality data, call it Table 1. That batch number is a link reference for multiple other tables that log other parts of the process (call it table A, B, and C).

However, I can only have the batch number column in Table 1 have a link reference to either Table A, B, or C - not all 3 at the same time. Is there a way to have 1 column with multiple link references? Right now I'm working around it by duplicating the batch number column multiple times, and each one with its own reference to A, B, or C.

Thank you!

[#2 · Accepted solution]

I think the replication is easiest option. You could also create some supporting table(s) to either display all the data or to function as relationship/collector table and then link that to your main table (let the relationship table handle the replication).

New table (almost the same as just duplicating to main table)

Relationship table which "collects" sub table results and then gets pulled into main table

[#3]

Thank you very much! Glad I wasn't missing something. I like your idea of having 1 table to be the primary connector, that will help to clean up how my main data table looks.