Newby needs help (desperately)

[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

 

[MStef]

Hello jazztie!
I suggest next:
1) In RELATIONSHIPS link tables
"Tbl_Employer" -> "Tbl_Person" 1 -> more.
2) Make a MAIN FORM on Tbl_Employer,
Make a SUBFORM on Tbl_Person.
3) Link MAIN FORM and SUBFORM via
LINK MASTER FIELDS and LINK CHILD FIELDS.

 

[jazztie]

Hi MStef,

Where do I find this 'LINK MASTER FIELDS' and 'LINK CHILD FIELDS' in Access?

 

[Jibbadiah]

Jazz,

Create a query the references both tables, and then use the query as the basis for your form.

James

 

[jazztie]

I see...
I get it now... (this simple one)... I'll be back with more questions later

Thanx!

Jazz

 

[MStef]

Hello Jazztie!
If you still interested in MAIN FORM and SUBFORM,
look at "DemoEmployerPersonA2000.mdb".
Open Form1MAIN.

 

[jazztie]

Hey MStef,

Thanks for the example...
However, I can't find the Source Object and LINK CHILD etc you mentioned. I'm using Office XP, maybe you have functions I don't have?

However, I did find the relationship window - not via the FORM, but in the topmenu.

Jazz

 

[MStef]

I have got XP too, Open Form1Main ind design view,
click on SUBFORM (not label), click on PROPERTIES icon, (all), there must be.