Displaying data from multiple tables in one layout

[rkass068]

I posted in a previous post on the filemaker forums and got no help so hopefully someone here can help me out.  I want to display data in the following format on a layout in order to track what a hospital clinic is doing for each patient. I want to display the following: There are 4 tables displayed on this spreadsheet type report that I attached. light blue=laboratory work, pink=biochemistry, dark blue=visit outcomes and orange=treatment. Currently I only have a table for treatment and laboratory work.

In my database I have a table called "main" which has all of the patient demographics. Laboratory and treatment are related to main in a 1:many relationship since 1 patient can have many laboratory outcomes and more than one treatment. I was wondering how I could make a report to show these tables and arrange them by most recent date done (a field in each table designated "date").

I was also thinking that since laboratory and treatment tables aren't related directly if I could just put all of the fields from those tables into one giant table and use conditional formatting to know which fields to display. I tried this method and it worked; however, I dont know if it is a good idea for stability and if it will make the user confused. Thank you i greatly need and answer to this

database lab report.pdf

[Ocean West]

You may want to research the forums for Virtual List concepts and with either looping scripts and or Execute SQL function to get the data set(s) you need can draw this data in either a portal or a list view. 

 

keeping original data where it is but using Virtual List for display or printed purposes.

[rkass068]

You may want to research the forums for Virtual List concepts and with either looping scripts and or Execute SQL function to get the data set(s) you need can draw this data in either a portal or a list view. 

 

keeping original data where it is but using Virtual List for display or printed purposes.

Thanks so much for the help! I am having trouble tho figuring out what to do for this technique. I have researched and seen some examples, but none like mine. I never used SQL in my life and I am wondering if someone could help me out. If you want I can upload all my tables and fields to help. 

 

Thanks so much

[rkass068]

So I have been searching a way to make a virtual list from multiple tables to display the results in a portal and I can find no information on virtual lists from this forum. The examples on the web are not helpful for the purpose of my database. I can see how an execute sql function or loop script can work however I do not know how I can do it. 

[brian rich]

Perhaps these demos will help you?

 

http://seedcodenext.wordpress.com/2011/11/05/virtual-list/

 

http://www.mightydata.com/blog/taming-the-virtual-list-part-i/

 

http://fmforums.com/forum/topic/82287-virtual-tables/

 

Brian

[bruceR]

http://concise-design.com/downloads/basicvlist.zip

 

http://concise-design.com/downloads/memorydb.zip