relating multiple records together

Discussion created by erickaczmarczyk on Jan 28, 2013
Latest reply on Jan 28, 2013 by jimfeuerstein

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.


Any thoughts?


many thanks.