>>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
better to 1) write your own RI code or 2) use a product like xCase that can handle concatenated keys...