Multiple tables - Multiple forms (Access 2000)

Hi,

I am creating a database for an engineering application, it currently
consists of 7 tables all linked by one-to-one relationships (all with the
same autonumber primary key: 'ID') as ideally i would have liked one big
table but there were too many fields for one table so I thought the
one-to-one relationships would 'simulate' this.

The fields from these tables are displayed on 5 different forms each
containing the 'ID' field, now when I enter data into one of the forms (and
therefore one of the tables) this creates a record in the table containing
that field and generates a value for 'ID' for that record, but I would like
Access to generate a new record in every table (and therefore all the forms)
for this 'ID' value.

Is this possible? I'm sure there must be a more effective way of doing this
but I am relatively new to access and I'm still getting to grips with it.

Thanks a lot guys,

Alastair