Access 2000 Data entry

[Interspiro Mark]

I have a database with 4 tables. I want to enter the value for my primary key
field in a form and have it entered into all 4 tables. The relationships are
set up and the fields all have the same name. Is there a way to do this. Even
better, can I use the autonumber fieldtype in filling these fields with the
same number?

 

[storrboy]

No. There is no guarantee that the number will be the same. When the
tables are related, the idea is that one of them is a master table and
the other children. A record must first be created for the master
table, then info can be added to the others. The method of input will
determine when the key field is applied in each. If all four tables
are populated at the same time, then the key field has to be applied
at the same time.

 

[John W. Vinson]

On Thu, 22 Mar 2007 14:30:13 -0700, Interspiro Mark <Interspiro

I have a database with 4 tables. I want to enter the value for my primary key
field in a form and have it entered into all 4 tables.

Ummmmm...

No. You almost certainly do NOT. Creating empty "placeholder" records is
always a bad idea - they tend to never get filled, or get filled incorrectly.

The relationships are
set up and the fields all have the same name.

If each table has the same set of fields, your table design is very unlikely
to be correct.

Is there a way to do this. Even
better, can I use the autonumber fieldtype in filling these fields with the
same number?

No. Autonumbers are meaningless, arbitrary, and uncontrollable.

What real-life Entities do these four tables represent? Why four tables not
one? What are the fields? Are you perhaps "committing spreadsheet" and using
four 255-field tables in order to accommodate 1000-odd fields? If so,
Normalize! "Fields are expensive, records are cheap."

John W. Vinson [MVP]