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