Ok, Need to create a layout that similar as to what is in the attachment.

The problem is that I would like to show records from two different sources in the body.

The body would have three fields from each table. What I am running into is that it seems that if there are 5 records from table 1 and 10 records from table 2, it only shows 5 records from each.

Any Ideas?

Thanks

Fred

Actually, I just looked again and found that it actually shows all the found records in table 1 and the same number of records in table 2 but the data in the table two records is only the first record shown the same number of times as the number of records in table 1.

Very hard to explain.

Edited March 17, 200817 yr by Guest

Have you tried using portals for each one? Also what are the subsummaries based on?

Prevent the entity duplication in your normalization, the data doesn't seem to be stuffed into a join table??

--sd

Thanks again for the response

This is a report layout. It is used for tracking the overdue payments for 2 different payment schedules. We build Condominium projects. We provide in house financing. the financing is done in 2 phases. the construction phase and the balance. The customer signs a contract and agrees to pay a deposit say 20%. They will then pay say 40% during the construction phase. The remaining 40% over a 1 to 5 year period.

Table 1 in the example is the overdue payments in the construction phase and table 2 the balance phase.

I would like to avoid the use of 2 separate reports, one for each phase and combine them into a single report

Hope that helps. I have attached what I have so far.

PS The attached has the portals in them but that doesn't work

Contract.zip

Edited March 18, 200817 yr by Guest

Couldn't you have uploaded it without the privilege settings, it makes it unnecessary troublesome to say anything serious about it!

--sd

Don't be such a fuddie duddie, Soren ... we all forget about the password from time to time. Heck, I've even done it myself. Oh, okay, nuff said there ... I expect a response like, "yeah, my point exactly!" Ha ha ah!

Edited March 18, 200817 yr by Guest

Hope this is a little better.

Sorry

Also Has been Modified a little.

Thanks

Contract.zip

Edited March 18, 200817 yr by Guest

After much thought, it seems to me that I would be better off combining the Construction and Finance tables and using REPEATING fields to track payments. I know you should not use repeating fields to store data but I also know there are exceptions to that rule.

Repeating fields would make the reporting much easier.

Thoughts?

Don't be such a fuddie duddie, Soren

I deeply apologize, for not facilitating my posts with enough emoticon'izations when meant ironically. Having seen eposides of "Friends" should have made me aware of the correct way to convey subtleties, even though that the series provides a canned laughter each 0,7074 minute, should the correct gestures be in place too!

--sd

:)

Repeating fields would make the reporting much easier.

Perhaps, as long as all your payments goes to the one and same source table, that by the way too facilitate the payment type too. Then could you in the presentation layer make good use of:

http://edoshin.skeletonkey.com/2006/12/crosstab_report.html#more

In you graph are every table showing up in single occurance BTW ...the RG isn't an ERD, perhaps you should re-read:

http://www.digfm.org/ref/FM7_key_concepts.pdf

--sd

Perhaps, as long as all your payments goes to the one and same source table, that by the way too facilitate the payment type too. Then could you in the presentation layer make good use of:

http://edoshin.skeletonkey.com/2006/12/crosstab_report.html#more

In you graph are every table showing up in single occurance BTW ...the RG isn't an ERD, perhaps you should re-read:

http://www.digfm.org/ref/FM7_key_concepts.pdf

--sd

Thanks for the reply.

I realize the difference between And ERD and the RG. But the links will give me a greater understanding of the entire DB concept. I really appreciate your help. I have learned much from your references in the past, no matter how esoteric.

Again thanks.

Fred

BTW You are right there at that stage they were only single occurrences.

Now three are in multiple occurrences... Sometimes my oldtimers kicks in and I forget that multiple TO's can make things much easier.

Edited March 19, 200817 yr by Guest

Nah, Soren, you're okay by me! I've just seen us all (at different times) get in trouble because of our wording and it appeared that you were chastising because of no password when a simple 'give us the password' would have worked. I was attempting to lighten it up a bit at your expense, sorry.

I put smilies all over my posts and, if I don't, someone thinks I'm mad. Ha ha. I just didn't want to see any feelings get hurt or feathers get ruffled but it truly isn't my place to be peace-maker anyway. I must be in a 'mamma' mood. My apology for stepping in - I didn't do it as moderator but as a friend. :blush2: