View Full Version : Form that reference another table twice


rklchow
12-13-2001, 10:20 PM
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

Pat Hartman
12-14-2001, 04:21 AM
Create a query. Add the Relations table and then add the Members table twice. Access will append "_1" to the end of the Members table name for the second instance. Draw join lines from the first reference field in Relations to Members. Select the Name fields. Change their names so that you know that this column is "FatherLastName". Then draw a join line from the second reference field to the second instance of Members. This time when you select the last name, call it "MotherLastName". By naming the fields appropriately, you'll be able to use them without confusion in your forms/reports.

rklchow
12-14-2001, 08:23 AM
create a query for client?
like
select * from member;
and what is the query for?
cos i still cant get it to work
Thanks

Pat Hartman
12-16-2001, 05:06 PM
The query will be used as the recordsource for the form. Why don't you post your attempt to follow my directions and someone will help you correct it.