Hello,
I have designed an Access Database for my friends heating business. I have just 2 tables [customers] and [servicing]. Both have numerical ID's for each record. [customers].ID is autonumber and [servicing].ID is number. The ID in each case is the tables primary key. The [servicing] table includes several fields from the [customers] table (title, surname, phone# etc.)
A 1 to 1 relationship links the two primary keys.
So that a [servicing] record is created whenever a [customer] record is added, or removed when a[customer] record is deleted, I enforced referential integrity with update and delete boxes ticked.
Unfortunately the auto update and delete dont work. The database works fine if you manually add or delete [servicing] records when adding or deleting [customers].
Can anyone tell me what I've missed?
TIA
Christine.
I have designed an Access Database for my friends heating business. I have just 2 tables [customers] and [servicing]. Both have numerical ID's for each record. [customers].ID is autonumber and [servicing].ID is number. The ID in each case is the tables primary key. The [servicing] table includes several fields from the [customers] table (title, surname, phone# etc.)
A 1 to 1 relationship links the two primary keys.
So that a [servicing] record is created whenever a [customer] record is added, or removed when a[customer] record is deleted, I enforced referential integrity with update and delete boxes ticked.
Unfortunately the auto update and delete dont work. The database works fine if you manually add or delete [servicing] records when adding or deleting [customers].
Can anyone tell me what I've missed?
TIA
Christine.