I am working on a way to link multipe records together.
Essentially our database has records identified by a unique inventory number.
Phsyically the inventory has both photographic prints and negatives in one table.
What I would like to do is be able to link the negative to the print.
An example of three records that need to be somehow linked together are : JS.93, JS.279 and JSN.011704
What I would like to happen is, in a portal, we can see the other two related items.
For example: looking at JS.93 we can see JS.279 and JSN.011704 - or - looking at JSN.011704 we can see JS.93 and JS.279.