467,212 Members | 1,189 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,212 developers. It's quick & easy.

Creating Report with two one-to-many relationships

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
  • viewed: 1685
Share:
2 Replies
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
"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.

Similar topics

1 post views Thread by Tim Graichen | last post: by
2 posts views Thread by Tony Williams | last post: by
2 posts views Thread by GaryDean | last post: by
reply views Thread by neeraj | last post: by
4 posts views Thread by fredindy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.