Creating Report with two one-to-many relationships

[Andrea]

I'm having some difficulty creating a report in Access and I need some
suggestions. My company issues "Return Authorizations" when customers
need to return products. A customer calls in and we provide the
number. The customer then returns items for a refund or for an
exchange. Here is the basic set up of the tables in question.

-ReturnAuthorizationTable-
ReturnNumber_PK
CustomerID
ReturnType
ReturnReason
Comments

-ReturnTable-
ReturnID_PK
ReturnNumber_FK
Product
Quantity
Status

-ExchangeTable-
ExchangeID_PK
ReturnID_FK
Product
Quantity
From my table setup, I have two one-to-many relationships to the
return authorization table. So far, I've successfully created a
report that will show 1 (and only 1) return authorization (RA) and
list all of the items returned and all of the items sent in exchange.
The only way I was able to do this was by creating a form where
someone selects a single RA# from a combo box. Using the RA#
selected, I run three different queries, and create a single report to
view all the information.

However, now I must expand on this and allow more than one return
authorization to be FULLY reported on. I'm having difficulty creating
a query to retrieve all of this information. Am I trying to do the
impossible? Can a report be created for a relationship like this?

I would appreciate any suggestions anyone has to offer.

Thanks in advance,
Andrea

[Tony Toews]

starwars <no****@tatooine.homelinux.net> wrote:

Comments: This message did not originate from the Sender address above.
It was remailed automatically by anonymizing remailer software.

Folks, please ignore the above posting.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[Larry Linson]

"starwars" wrote

Hey Salad, why did you change your
nick from U N Me?

I'd wager it wasn't for the same reason that you change _your_ alias on a
frequent basis -- whatever his "nick", he isn't a troll.