Report Builder-Joins Question

Yahoo Archive
1
Rick
When you joined the RMAHead to the Customer table did you
actually get the RMAHead fields?I just did a test of the report
you describe. RMAHead to RMADtl by Company and
RMANum. Then RMAHead to Customer by Company and
CustNum. I have exactly the number of records I expected.

When I went to join RMAHead to Customer RMADtl fields
came up by default. It has to be RMAHead.Company to
Customer.Company and RMAHead.CustNum to
Customer.CustNum.

HTH
RussD

On 11 Jun 2001, at 14:04, Rick Gors wrote:

Help.

I have a report using the RMAHead table. All is well.

I then join RMAHead to RMADtl and add some fields. All
is well.

I then join RMAHead to Customer to get the customer
name to print along
with the customer id. But nooooo. I keep getting 10
or 20 of the same
report, page after page, of the same thing. I've tried
changing from
RMAHead to RMADtl, from Left Outer (?) to All, all
kinds of things.

What should my thinking be here? Obviously it's pretty
twisted right
now.

Thanks a billion in advance for any help!!!!!

Rick Gors
MR/MMIS
Osco


[Non-text portions of this message have been removed]



Russ Dover
IS Manager
Weaver Industries, Inc.
717 336 7507 phone
717 336 4182 fax
rdover@...
www.weaverind.com
2
Help.

I have a report using the RMAHead table. All is well.

I then join RMAHead to RMADtl and add some fields. All is well.

I then join RMAHead to Customer to get the customer name to print along
with the customer id. But nooooo. I keep getting 10 or 20 of the same
report, page after page, of the same thing. I've tried changing from
RMAHead to RMADtl, from Left Outer (?) to All, all kinds of things.

What should my thinking be here? Obviously it's pretty twisted right
now.

Thanks a billion in advance for any help!!!!!

Rick Gors
MR/MMIS
Osco


[Non-text portions of this message have been removed]