>>>Hello.
>>>
>>>Does anybody know what "INDEX BASED ON EXPRESSION" is?
>>>
>>>When I try to set up a referential integrity in my vfp database, it say that "INDEX BASED ON EXPRESSION" may not behave as expected do you want to continue?
>>>
>>>thanks bunch.
>
>>It means you're using something other than just the field in the index tag. For example, you may have UPPER(Name).
>
>Hi Craig, i use integer for my primary keys and somtimes i have to do something like this "str(garment)+str(service)", where both "garment" and "service" are primary indexes for their respective dbf, to create my compound index.
>
>How would i get around the data integrity warning with this.
>
>thanks.

One way is to use another field with an autogenerated integer as the PK for this table and just use the Garment and Service as FKs to their respective parent tables.