>>>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.
I would still use an integer as the PK.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer