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