>>In my database designer I'm assigning relationships between all the primaries keys in my tables, that then I drag onto the forms I'll be using. My boss, who knows some VFP says they are not truly reliable and that it's better to create your own as you go. What do you guys think?
>
>I haven't found them to be any more or less reliable than manual relationships, but they sure can be SLOW when you have multiple relationships and you're doing a multi-record DELETE, UPDATE, or REPLACE.
I agree, you can end up getting Fox to do alot of extra work when you didn't intend it to do so and this is wholly unncessary. I find it much 'cleaner' to just code a SEEK or a LOCATE exactly when I need it.