Report problem

[Wayne Heidler]

I have a primary table and 3 child tables.
Contact
Spouse
Children

They are one to many relationship. There is no problem viewing the
tables in Forms, but when I go to print out a report, the contact
information is printed for itself and then for each record in the child
tables. Is there a way to have the report only print out the contact
once and then have the child table information printed?

Also, is it possible to switch the relationship back to one to one?

Thanks,
Wayne H.

 

[Allen Browne]

Wayne, I probably should not try answering this, as I am not sure I
understand what you are doing. I will try to answer the specific questions
you asked.

Reports have a Sorting And Grouping dialog (View menu, in report design
view.) You can use that to create a Group Header based on the ContactID. The
header should then appear once only.

Based on your indenting, it seems your primary table can have mutiple
contacts, and your contact can have multiple spouses and multiple children.
If so, there is a problem in that you do not have 2 detail sections for the
spouses and children. One of them (probably children) will probably have to
become a subreport. You could put this into the ContactID group footer, so
it is printed once only for the contact, and not for every spouse.

Not sure what relation you are trying to switch back to 1-to-1 or why, but
try putting a unique index on the foreign key in the related table. The
primary key of the primary table already has a unique index, so if the
fields in both tables are unique, you have a 1-to-1 relation.

The main issue I have in understanding your structure is that it seems to me
that the contacts are people (like your main table), the spouses are also
people in their own right, and the children are people too who will one day
grow up and have children and spouses of their own. It therefore seems to me
to be redundant to have the people spread over these 4 tables when they are
all people, and you seem to be trying to track the kinds of relationships
that exist between people. For an alternative way to handle this, see:
People in households and companies - Modelling human relationships
at:
http://allenbrowne.com/AppHuman.html

 

[Wayne Heidler]

Allen,

You hit it exactly, thanks...
I will look at the web page that you gave and see how to re-adjust. Once
again thanks,

Wayne