G
Guest
Hi, I'm creating a very simple database with some students, their locations
etc. I have three tables set up, and I have them related. The main table is
'demo', and two sub tables are 'school' and 'info'. I have 'demo' related to
both 'school' and 'info' with a one to one relationship.
I've created queries and forms for input, and the data enters the database
fine. I have yet to create delete queries and that's where my problem comes
in. As a test, I tried to delete a record in the school table.
Unfortunately I was sucessful. My thoughts were since I have the school
table related to the main 'demo' table, I would only be able to delete a
record if I deleted the record from the demo table. However that's not
what's happening.
As I stated earlier, I have one to one relationships between the tables, and
I've enforced referential integrity. I've also checked the 'cascade delete
related records. Should that box be unchecked?
I appreciate any help you can offer. Sorry to be so long winded.
T.
etc. I have three tables set up, and I have them related. The main table is
'demo', and two sub tables are 'school' and 'info'. I have 'demo' related to
both 'school' and 'info' with a one to one relationship.
I've created queries and forms for input, and the data enters the database
fine. I have yet to create delete queries and that's where my problem comes
in. As a test, I tried to delete a record in the school table.
Unfortunately I was sucessful. My thoughts were since I have the school
table related to the main 'demo' table, I would only be able to delete a
record if I deleted the record from the demo table. However that's not
what's happening.
As I stated earlier, I have one to one relationships between the tables, and
I've enforced referential integrity. I've also checked the 'cascade delete
related records. Should that box be unchecked?
I appreciate any help you can offer. Sorry to be so long winded.
T.