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?