not all member in the same page

[Frank Situmorang]

Hello,

I have resolved the problem in my previous thread, and now my problem that
the member of the family is not gruop into 1 page, but combined with other
family member in another addresss/household

What I want is this serves as a letter to update each household data. What
goes wrong while it works in the form using 1st tab as household data and
members in the 2nd tab.

Thanks for any idea provided.

 

[Allen Browne]

Frank, this is quite a big question.

Here's a very flexible solution that lets you choose the people to include
in a mailing, as either a household or as individuals:
People in households and companies - Modelling human relationships
at:
http://allenbrowne.com/AppHuman.html

That may be more than what you need, but you have been asking lots of
questions, so I think you are ready to consider a relational approach like
this.

 

[Frank Situmorang]

thanks allen for your quick response and the website you gave me. I have
checked the website and it is similar with address sample of MS database.

I have successfully made it in the form using tab of course with child and
master link fields.

My problem, I want to make it in the report, the member tab is to be a
subreport in the report, it can shows up, but the problem is that members in
the subreport are not from the same address/household

I appreciate your help.

 

[Allen Browne]

So you have set up the tables, with the relationships, and entered data so
you know who belongs to which household, but you are getting way too many
people showing up in your subreport (not just the members of the household
in the main report.)

If that's what is going on, it sounds like the linkage between main report
and subreport is not set up correctly. So:

1. Open the main report in design view.

2. Right-click the edge of the subreport control, and choose Properties.

3. On the Data tab of the Properties box, set LinkMasterFields and
LinkChildFields.

LinkMasterFields should contain the name of the control in the main report
that identifies the household. LinkChildFields should contain the name of
the matching field in the subreport.

 

[Frank Situmorang]

I have checked that Allen, it is ok, but the case now it is not mixed with
the other member of the household, but it repeats the same member.

For example in houshold P ( Main report)
There are 2 members ( in the subreport)
Mr. A
Mrs. B.

But it shows in the report view:
Mr. A
Mrs.B
Mr. A
Mrs. B

Why it is repeated 2 times in the page.
The other problem I want it that if more than 4 members ( because it fits 4
member in one page, it goes to the next page, and the closing sentence (
which is page footer) will go in the next page, since in Indoensia could be a
lot of members in one household, we want it go to next page if more than 8
and so forth...

Thanks for your help Allen

 

[Allen Browne]

Frank I can't see your data structure, so I can't see why they are repeated
in the subreport.

I'm guessing that the RecordSource for the subreport must be a query that is
not set up correctly, so the query repeats the people in the household, and
so the subreport just does what the query says.

 

[Frank Situmorang]

OK thank you Allen, you are right, that main report should have recourd
source from address table, not query, because in my address query it has
address ID, so it shows again in the subreport.

Thanks very much it is ok now.