How to Retrieve information from 2 tables in a single form

[naveen prasad]

Hi all,
Pls help here..

I have an access file consists of 2 tables x1 , x2.
x1 fields are name, place.

x2 fields are name, desg, salary, mobile_no.

Forms f1, f2,
pls note... place and name are unique(not repeated).

I have created a form f1, added a combo box taking all places from table x1.

now when I click / select a place in combo box, It should display all the
fields

of table x2 in form f2.

the logic is place selected in combo box should retrieve the corresponding
name from x1 and match the name in table x2 and get the details from x2 and
display in form f2.

pls help me how can i do it.

 

[Jerry Whittle]

If name is the primary key field for table x1, then join it to the name field
in table x2 in the Relationship Window. Enforce Referiential Integrity.

Next make a form bases on table x2 a subform on a form based on table x1. No
combo box needed.