erickaczmarczyk

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.

Outcomes