By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,468 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

Creating Report with two one-to-many relationships

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Nov 12 '05 #2

P: n/a
"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.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.