By William Fields - 10/31/2013
Hello,
I have the following relationship in a VFP database that I'm trying to set up as a SQL relationship in the DDT:
| Parent Table | Update | Delete | Insert | Child Table | | TableA | Cascade | Restrict | Ignore | TableB |
But, when I uncheck "Enforce relationship for INSERT's and UPDATE's", the Update Rule combobox forces "NoAction" rather than "Cascade".
I'm not certain if unchecking the enforce option is the right thing to do in the first place (see my other post on a similar question), but how would I set this type of relationship up in the DDT?
Thanks.
Bill
|
|