Query Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I don't know if this is possible in Access, but I thought this would be the place to ask... I have a library, where I have 2 member tables, "Student Members" , and "Teacher Members". I have a 3rd table, "Borrowed Books", where I place their members ID's in. (The 2 members tables are related to the borrowed books table). I want to make a query in the form of Borrowed Books, where with one click, it will search for the Member ID in both member tables, and display the results of the table where the Member ID was found in. Can anyone help with this?
 
HI:

Make a query and add the [Student Members] , [Teacher Members] and [Borrowed
Books] tables. Link the tables by member ID fields from the first two tables
onto the 3rd table. Then under the [MemberID] field, you add to the query
among other fields, place the following criteria

like form![ChooseMember]![MemberID]

This will popup a window for you to enter the ID. This assumes a form called
'ChooseMember' exists as well as an unbound field named [MemberID] is on
that form. If it doesn't exist a window will still popup with an input
field.

regards

Adamos H. said:
I don't know if this is possible in Access, but I thought this would be
Click to expand...
the place to ask... I have a library, where I have 2 member tables,
"Student Members" , and "Teacher Members". I have a 3rd table, "Borrowed
Books", where I place their members ID's in. (The 2 members tables are
related to the borrowed books table). I want to make a query in the form of
Borrowed Books, where with one click, it will search for the Member ID in
both member tables, and display the results of the table where the Member ID
was found in. Can anyone help with this?
 
This doesn't help with your immediate problem, but I would like you to
consider combining the two tables into one and add an extra field which
differentiates students from teachers. This way, you would only have to
search one table.

--Roger Carlson
www.rogersaccesslibrary.com

Adamos H. said:
I don't know if this is possible in Access, but I thought this would be
Click to expand...
the place to ask... I have a library, where I have 2 member tables,
"Student Members" , and "Teacher Members". I have a 3rd table, "Borrowed
Books", where I place their members ID's in. (The 2 members tables are
related to the borrowed books table). I want to make a query in the form of
Borrowed Books, where with one click, it will search for the Member ID in
both member tables, and display the results of the table where the Member ID
was found in. Can anyone help with this?
 
Back
Top