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.



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,
Nov 12 '05 #1
  • viewed: 1685
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 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
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.