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.
|
|
|
 |
|