Forms for multiple tables using one field to connect

[cbramsey]

Here are the three tables I have:

1. Tract
a. Tract ID (PK-autonumber)
b. Section
c. Quarter Call
d. Tract number
2. Tract Description
a. Tract ID
b. Description Text 1
c. Description Text 2
3. Tract Factor
a. Tract ID


b. Gross Acres
c. TPF

I have one form for tract data entry where all of these fields are entered, what I am wanting is when i start a new record, I get the autonumber to populate the tract ID in each table since that is the linking factor. I know this can be done but I am having a heck of a time trying to figure it out.

[jwhite]

Looks like to me the MainForm will be bound to table "Tract", and then you would have two subforms, each bound to table "Tract Description" and table "Tract Factor". I don't see a Primary Key listed for the two sub tables. In the subform control for each, you would put TractID in the Master and Child Link properties.

On the surface, it looks like this should all be in one table? For one, having multiple description records for a single Tract doesn't make sense.

[cbramsey]

I am using multiple tables to speed up the query process. The reason for two descriptions is that there are times when the description is longer that 255 characters.

Thanks for the help on the subforms, i am going to try that and see if it gets the desired result