I have 2 master Tables, one of which contains Clients and one of which contains suppliers.
I have a third child table which contains contacts for both Clients and Suppliers. (in other words it is shared)between the 2 master Tables.
Client is joined to contacts via ClientID and Suppliers is connected to suppliers by SupplierID.
When I click a link in the Client master table a Contact List Page opens with that Clients contact records and other information.
The same goes for the Supplier master table.
However depending on whether I have clicked through from a Client or Supplier I want to display different columns. I thought the best way would be to start with all columns in place and then hide the ones I don't want displayed depending on which Master Table it has opened against.
Hope this make sense and look forward to any constructive solution or alternative ideas.
Carl.