cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
Polygon0516
Level I

One Column with Multiple Link References

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!

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: One Column with Multiple Link References

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)

jthi_0-1738647750936.png

 

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

jthi_1-1738647825814.png

 

-Jarmo

View solution in original post

2 REPLIES 2
jthi
Super User

Re: One Column with Multiple Link References

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)

jthi_0-1738647750936.png

 

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

jthi_1-1738647825814.png

 

-Jarmo
Polygon0516
Level I

Re: One Column with Multiple Link References

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.