AnsweredAssumed Answered

Linking Tables

Question asked by Kaps_1 on Jul 2, 2012
Latest reply on Jul 2, 2012 by philmodjunk


Linking Tables


I am building a solution for a brokerage where contacts can buy /sell stuff with other contacts. I have two tables - one called contacts and the other items. I am trying to create a relationship between them in such a way that I can display a portal of all contacts to the left of a particular item.

I will then write a script that clicking on a particular contact will assign it to the item. However I cant think of a meaningful way of constructing the relationship between items / contacts.


I have upload a screen shot of the layout and browse mode, and relationship diagram to :-


curretly I have contact_id__ x item_id