DDT and Relationships

William Fields — Thu, 31 Oct 2013 16:39:00 GMT

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

StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » DDT and Relationships

DDT and Relationships