Hi all
I have a question that I can't seem to find the answer for on the forum but theoretically seems possible.
I have a master table (clients) and around 20 child tables (eg: assessment, progress_notes, questionnaire, diary etc). I would like to be able to call the master table record as a variable, so that the vertical menu items link directly to the child records for the selected record.
eg:
CLIENT (id no, name)
-- assessment link
-- progress notes link
-- diary link
-- questionnaire link
I know I can do this in the list view, but with so many child tables its is slow to load them all when the details button is clicked and I don't like the appearance.
I have made a work around: a custom view of the master table from search with a custom button "open records": --> search for client -> click button -> dashboard view for specific client. This works nicely but it can be slow to load so many child tables on the dashboard and makes for a very big screen. My final solution was to add detail tables in the tabs of the view page - but it is not possible to view details by clicking, or to add/edit if it is not inline.
Is there a way to either:
a) create a vertical menu of child tables based on the master table, or
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=24504&image=1&table=forumtopics' class='bbc_emoticon' alt='B)' /> add a menu system to dashboard?
Thanks
Terry