I have three .dbf named dcountry1, dstate1, ddistrict1

1.
table: dcountry1.dbf
fields: country
index: country candidate

2.
table: dstate1.dbf
fields: state, country
index: country+state candidate
country regular

3.
table: ddistrict1.dbf
fields: district, state, country
index: country+state+district candidate
country+state regular

Set Relation:
1. country(dcountry1.dbf) into country(dstate1.dbf)
2. country+state(dstate1.dbf) into country+state(ddistrict1.dbf)

At the time of prepare RI I am getting a message like following:

Cascade updates that are based on expression-based index keys, may not behave as expected. The system has identified expression-based keys in the following relationship;

dstate1 + ddistrict1

Select Ok to continue with RI code generation. (Note: You can override the generated __ri_update_*code by creating stored procedures of the same name, and including those stored procedures AFTER the end of the generated RI code.


I would like to know how to solve the problem. How to set correct RI.

Regards,