>Please, could someone help me to solve this problem.
>For Visual FoxPro 3.0
>I have two tables in DBC which keys are complex , for ex. field1+STR(field2,6)
>and relationship between them are one to many. Referential integrity on update the parent field
>cascade child table with the new key value always failed (trigger failed )?
>
>Thanks in advance.
>
>Please reply on mail kreda@eunet.yu
VFP (I believe) was designed to work best with a single field primary key. The easiest solution would be to add a new field=field1+str(field2,6) and use that as your key field.
Larry