Form that reference another table twice

rklchow

New member
Local time
Today, 21:15
Joined
Dec 13, 2001
Messages
8
Hi
I m very new to access and I need some help
I want to make a form that has reference to the same table twice
example
I have 2 tables, one called Member and one called Relations
In Member has all the details of the Member and Relations has 2 reference to Member's ID
I want to make a form which displays the first name and last name of both members when I select their respective client numbers
Thanks
 
create a query for client?
like
select * from member;
and what is the query for?
cos i still cant get it to work
Thanks
 

Users who are viewing this thread

Back
Top Bottom