A
Alastair
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
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