AnsweredAssumed Answered

Linking Tables

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

Title

Linking Tables

Post

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 :-

 

http://www.4shared.com/office/tE3V1hFM/fm_online.html

 

curretly I have contact_id__ x item_id

 

Thanks

 

Kaps


Outcomes