dang
Posts: 11
|
| Posted: 11/23/2007, 5:34 PM |
|
Hi
I add in MSAccess a relationship between 2 tables. I do not allow to delete a parent record when this one have some child records.
Is there a way to avoid this message:
[Microsoft][ODBC Microsoft Access Driver] The record cannot be deleted or changed because table 'Transactions' includes related records. (Microsoft OLE DB Provider for ODBC Drivers)
and replace it by a more friendly one.
Regards
_________________
Dan |
 |
 |
Oper
Posts: 1195
|
| Posted: 11/23/2007, 7:16 PM |
|
keep the relation just to be safe.
but you will use: on validate function on any field.
and do a ccdlookup("Count(*)",..................
for the records on the other field/database if > 0
then adderror will do the job.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
|
