report of linked tables

  • Thread starter Thread starter Aten
  • Start date Start date
A

Aten

hi,
I have a db which has a main form where you enter details
such as name,id, etc, then you click on a button and you
can enter multiple addresses for example, for each record.
I would like to create a report for 1 individual record,
which shows all the main data, AND all the multiple
addresses and other tables which are linked to that
record. I can show records that has 1 person, 1 address
for each address, so the same person shows up for each
address they have, but I would like to show 1 person, and
all addresses, all phone numbers etc for as many different
tables that I have created that "belong" to each person.
How can I do this?
Cheers
 
From your description I think you are placing all adresses
and phone numbers into the same table and you are
duplicating the related name data.
If so, what you can do is create a report which is grouped
by the name data, Now place the name data in the group
header band and the address ad phone number in the detail
band. This should work. or, if you wish you can place
all the text boxes in the detail band and set the
properties for the name data "hide duplicates" to yes. If
you properly arrange the datafileds and set the "can
shrink" property of the band to "yes" this could also work.

There is a basic mistake in this type of arrangement. I
would rather create one table with the name data, and than
a related table with asn many addresses and an other with
as many phone numbers as wish, than create a report based
on these three tables combined in a query.

Hope this helps.
 
Back
Top