CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 The record cannot be deleted or changed

Print topic Send  topic

Author Message
KTI
Posted: 04/18/2002, 12:27 PM

Hi,

I have couples of table in an Access DB, there are relations between them (one to many). Once i insert a record in Table1, i can insert many record to Table2 and it'll link to Table1. I can go back to Update/Delete information on Table2, however, if i go back and changes information on Table1 i got this message "The record cannot be deleted or changed because table table_name includes related records"

I don't want to change the relationship that i have as now, and don't understand why that i can change the information on Table2 while can't do it in Table1.

Thanks in advance for your comment.
KTI
Posted: 04/18/2002, 12:43 PM

""The record cannot be deleted or changed because table Table2 includes related records"

This ONLY happend if there are information on Table2 that link to Table1. If en enter a record in Table1 and have not enter any information in Table2(link record) then i can still go back and edit information on the Record on Table1.

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.