Search and return all members with same trans# [Solved]

[sherriedunn]

I have a table of "members" and a table of "orders".
Each "order" is a payment for their dues with other details of that payment.
...type membership...amount...transaction#...etc
One of the details of the order is the bank "transaction#" of their deposit.
But...many members' orders (dues) are deposited in the bank under one transaction# each week.

I would like to have a form that I can type in a bank transaction# and
it would return all the members' orders that were deposited under that transaction#.

I have a query of the "members" & "orders" and I can make a query that returns all transaction #s with a set value, i.e. 123, but I need to change the search for many different transaction #s.
Yes, I am a newbie and stumbling thru this. if anyone has the time to point me in a direction to find the answer, I would appreciate it. I have searched...but no luck.

[Sliderule]

sherriedunn:

Welcome to the world of OpenOffice Base.

You asked:

[sherriedunn]

Perfect! Thank you so much, Sliderule for taking your time to answer me! That looks like exactly what I need! I tried to search the answer myself, but was not successful. I really appreciate your giving your time to same me tons of time and I would have never figured it out!