AnsweredAssumed Answered

Complicated Relationship

Question asked by dinora on Apr 1, 2009
Latest reply on Apr 1, 2009 by dinora


Complicated Relationship


I have the following set up


Suppliers ----<Tours Suppliers>----------Tours


These tour which can be allocated to different suppliers has pricing that needs to connect to it so in theory I have another table called pricing


which needs to have the data on the pricing table allocated to each tour belonging to each supplier.


I want to have a portal in my suppliers table where I can display all the tours allocated to that supplier and be able to enter the pricing from the portal rather than the table.


Can anyone help?