Access Newby needs help (desperately) - ACCESS

[jazztie]

I have this form which shows the contents of a table... however, this table is linked to another table. How do I show the results of this linked table in the form?

Table_person
- Table_personID
- PersonFirstName
- PersonLastName
- EmployerID (linked to table below)

Table_Employer
- EmployerID
- FirmName
- ....

Now - the form should look like this:
First name: John
Last name: Doe
Firm: John Industries (selected in a dropdown box)

Table_Employer would contain
1 John Industries ...
2 Hank Industries ...

You catch my drift right?
How do I link these two tables in a form? How do I get the correct Firm to be selected in a dropdown box?

Any help is appreciated!!
Jazz

 

[cvo-aalst]

I have this form which shows the contents of a table... however, this table is linked to another table. How do I show the results of this linked table in the form?

Table_person
- Table_personID
- PersonFirstName
- PersonLastName
- EmployerID (linked to table below)

Table_Employer
- EmployerID
- FirmName
- ....

Now - the form should look like this:
First name: John
Last name: Doe
Firm: John Industries (selected in a dropdown box)

Table_Employer would contain
1 John Industries ...
2 Hank Industries ...

You catch my drift right?
How do I link these two tables in a form? How do I get the correct Firm to be selected in a dropdown box?

Any help is appreciated!!
Jazz

Jazz,

The easy way is to use a Subform in you main form.

The main form is bound to the mother Table and the subform is bound to the child table.
The use of Relations is a MUST !!!!!