I have a simple requirement but can't figure out how to implement it.
I want to display,
within a page,
a record from a table, and some values from associated records in other tables,
I want the user to first make a selection from a drop-down to determine what record gets displayed.
A simple example is:
- User selects Client Name from a drop-down
- The page then displays key information from the Client table for that client, and
- Details of each Site that the client has, from the Sites table, and
- Name and phone number of all Contacts associated with that Client from the Contacts table.
I've created a stateless form which allows the user to choose the Client Name and embedded that form in the page within a Div.
But...
a)
I don't know whether I should be using iframes or Divs to display the Views of the Client, Sites and Contacts tables
b)
I don't know how access the Client Name selected by the user so that I can use it as a filter on the Views.
(Note that I'd much prefer to use Views / Summary Reports where possible, to avoid detailed layout of individual fields using HTML)
Thanks for any guidance on this.
It's safe to assume that I may be missing something very obvious!
Alex