Viewing multiple records in multiple forms?
I have a clients form that serves as a lookup field for multiple other forms -- for example, a documents form, a phone calls form, a meetings form, a notes form. So, each document, phone call, etc. is tied to a particular client.
What I want to do is create a view or views that allows me to select a particular client and then view that client's information alongside each record from the other forms that are linked to that client. In other words, if I select John Jones as a client, I would then see every phone call, document, etc. relating to John Jones.
This could be either by way of one master view or multiple connected views that all tie in to one variable -- the client selected.
I haven't seemed to be able to figure out how to do this. Any suggestions? Many thanks in advance.