470,614 Members | 1,458 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

Referential Integrity that isn't

I seem to have gotten myself into a bit of a pickle. I am trying to
delete a record from a table attached to a form, and it complains
about not being able to delete a record in a table because "the record
cannot be deleted because table sales includes related records"
Cascade deletes and referential integrity right?

Well no. The table I am deleting out of has NO referential integrity
with ANY other table. I tried renaming and deleting the table and all
to no avail.

Here is my situation

Table1 is Sales and it has a company ID in it
Table2 is Company Table with company ID
Table3 is kind of a join with branches and headquarters of Companies.
It has ONLY the company ID of the headquarter and that of the branch

Table1 IS related to Table2 with RI (no cascade updates or deletes...)

The form for maintaining Table3 is a join on Company twice for the
purpose of displaying the names of the branch and headquarter company
for the user

Table2 Table3 Table2_1
ID-----------ID
Name SubID----------ID
Name
Then we display Table3.ID, Table2.Name, Table3.SubID, Table2_1.name as
subname

When I try to delete any record I get the can't delete record. If I
don't create the record source with the wierd 3 table join, it deletes
fine.

Ideas?

Thanks in Advance
Bob Rogers
Nov 12 '05 #1
2 1401
I have seen this before. Try compacting the database then try deleting
table.

--
Dean Covey
www.coveyaccounting.com

MS-Office Certified:
http://www.microsoft.com/learning/mc...st/default.asp

"Bob Rogers" <mi******@hevanet.com> wrote in message
news:91**************************@posting.google.c om...
I seem to have gotten myself into a bit of a pickle. I am trying to
delete a record from a table attached to a form, and it complains
about not being able to delete a record in a table because "the record
cannot be deleted because table sales includes related records"
Cascade deletes and referential integrity right?

Well no. The table I am deleting out of has NO referential integrity
with ANY other table. I tried renaming and deleting the table and all
to no avail.

Here is my situation

Table1 is Sales and it has a company ID in it
Table2 is Company Table with company ID
Table3 is kind of a join with branches and headquarters of Companies.
It has ONLY the company ID of the headquarter and that of the branch

Table1 IS related to Table2 with RI (no cascade updates or deletes...)

The form for maintaining Table3 is a join on Company twice for the
purpose of displaying the names of the branch and headquarter company
for the user

Table2 Table3 Table2_1
ID-----------ID
Name SubID----------ID
Name
Then we display Table3.ID, Table2.Name, Table3.SubID, Table2_1.name as
subname

When I try to delete any record I get the can't delete record. If I
don't create the record source with the wierd 3 table join, it deletes
fine.

Ideas?

Thanks in Advance
Bob Rogers

Nov 12 '05 #2
Well, I'll be hornswaggled!!! thank you Dean. That does in fact seem
to do it. Yet another case of Access remembering too many things for
it's own good.
I have seen this before. Try compacting the database then try deleting
table.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Bob Rogers | last post: by
7 posts views Thread by Jimmie H. Apsey | last post: by
5 posts views Thread by Geisler, Jim | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.