Lots of tables in one report

[Mental]

Hi,

I have a DB that I am going to be using on the hospital floor as a Resident. It has several tables:

Problems: Each problem is a new record and is given a "problem #"

Then linked to each problem # are other tables like:

- Medications: What I'm going to treat the problem with

- Tests: What I ordered to diagnose each problem

etc.

So, what I would like is a summary form that I can print a daily note from. It would look like this:

Hypertention

- Medication A

- Medication B

- EKG

Asthma

- Medication C

So basically it's like a project manager in a way. Each problem has several components linked to it. I can just go to the medication table and see what the patient is on. Or, I can go to the tests table and see what was ordered and when. I can't seem to figure out a way to list several tables in one form. Any advice?

- Randall

[aaa]

I can't seem to figure out a way to list several tables in one form. Any advice?

You can use relationships and portals for listing several tables in one form.

[Ender]

Portals have their limitations. They don't work so well for printed reports as they don't break correctly over page boundaries and they don't slide very well in FM7. If your daily note will fit on one or two pages, and you don't mind having some white space on empty portal lines, this may work fine.

If you need sliding, or you have a long report, I'd recommend using a sub-summary report based in a layout from Medications or Tests (use the more complex one.) Then for the other, use a ValueListItems() calc to pull related records into one text field.

You can see a simple example of this here:

http://forum.filemakerworld.com/viewtopic.php?t=6324

Alternatively, you could simply print the report in two pieces, the first part a sub-summary based on Medications, the second part a sub-summary based on Tests.