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

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.