Creating form to fill in other fields when PK field is filled in

[Guest]

Hi. I have 2 tables. (1) Master table with 1300 + records and primary key
and address fields; (2) Secondary table with a select number of records
linked by the primary key field. I want to create a form that will bring in
the address fields from Table 1 when I type in the shared primary key no.
between Tables 1 and 2.

Does that make sense? Any help is greatly appreciated.

 

[Guest]

Use the Form Wizard to create a Main / Sub form. Your "Master" is the main,
and your "secondary" is the sub.

 

[John W. Vinson]

Hi. I have 2 tables. (1) Master table with 1300 + records and primary key
and address fields; (2) Secondary table with a select number of records
linked by the primary key field. I want to create a form that will bring in
the address fields from Table 1 when I type in the shared primary key no.
between Tables 1 and 2.

Does that make sense? Any help is greatly appreciated.

Not really.

Relational databases use the "Grandmother's Pantry Principle": "A place - ONE
place! - for everything, everything in its place".

If the address information is in the master table then that's the ONLY place
it should be. Copying it into the secondary table not only wastes space, but
puts you at risk for data errors, since you now have more places to track down
and change if you need to change an address.

If you need address data in conjunction with secondary-table data, use a Query
joining the two tables.

John W. Vinson [MVP]