Layout with info from two tables

[Ell]

I have created a file with 2 tables. Table one is for participant information, and table two is for his/her entries. Each participant can have multiple entries. I want to create one sheet per participant, and include a list of their entries on that sheet.

I tried a subsummary section, but it only returns one entry per participant. What am I missing here--what's the best way to accomplish this?

[bcooney]

Design your report from a layout based on the "entries" table. You can subsummarize by the unique id of the participant.

[Ell]

Thanks for the tip.

I just found another way to do this, through the use of a portal, rather than a subsummary section. Worked like a charm.

Thanks again.

[comment]

Portal printing works reasonably well, but it's nowhere near as flexible as printing from the child table. No upper limit on the number of children per parent, any sort order for the child records, and individual record sliding are just a few examples.

Portal printing is a good choice when you need to include childless parents, though.

[cali]

Ell, how did you do it? It sounds like what I'm trying to do as well. I have multiple sports and participants. I want an easy way to work on a current season of a sport, but also have a table (table view) showing all participants for all sports/years.

[adario]

Hi bcooney,

I wanted to ask you a bit more about using sub-summaries.

I want to create a layout which is uses 8 tables.

Problem:

I'm trying to create a report which is basically an employee summary sheet of the person's last 5 years.

Each table has the employee's ID# as a primary key. When I create a report with 8 sub-summaries however, not all the information shows up in PREVIEW... neither the list of items nor the various catagories.

Can you tell me what I'm doing wrong? Am I not using the PART (sub-summary) correctly?

Table 01: basic employee information: name, title, years of service, etc.

Table 02: article they've written

Table 03: books they've written

Table 04: professional activities

Table 05: research

Table 06: honours

Table 07: presentations

Table 08: miscellaneous

Thank you for your help

Amy

[bcooney]

Amy, layouts only use ONE table occurrence. You can, however, include fields from related tables. It is difficult to create a report that is drawn from multiple child tables.

Your report may be most easily generated by basing the layout on your Employee table, and then simply using the List ( ) function to gather all related data from the child tables into text fields in Employees.

[Ell]

I simply did an Insert>Portal at the spot on my Participant form where I wanted to put the list of entries. Then you have to format the portal section the way you want it to look. Here's what my portal section looks like (see attached file).

Ell