By William Fields - 10/31/2013
Hello,
I have the following relationship in a VFP database:
| Parent Table | Update | Delete | Insert | Child Table | | TableA | Restrict | Restrict | Ignore | TableB |
What would the equivalent be in a SQL Foreign Key Relationship (alter table code example would be helpful), and how would I set that up in the DDT?
Thanks.
Bill
|
By William Fields - 11/14/2013
FYI - The only way to "Ignore" inserted FK records that do not have a corresponding PK record is to use .NULL.
This doesn't work for my scenario, but that's how this VFP functionality could be set up in SQL.
|
|