>>>>>Are any of these relationships one to many? Is your parent table somewhere other that EOF after the relationships are set and you look at child (months) tbales?
>>>>
>>>>All of the relationships are one to one. There is one record in each of the child tables for the parent table. I am not sure where the parent table record pointer is at when the relationships are established, but when I am browsing the various tables I move the parent record pointer around.
>>>
>>>You didn't happen to issue a SET SKIP anywhere did you?
>>
>>No. Simply SET RELATION TO.
>
>So ok, this does seem weird. The only other thing I canthink for you to check is your indexes? Each of your child month tables have index key that matches that expression you used with SET RLATION TO (someexpression)? If that's ok, then do you have any index on Parent table? Maybe try removing parent table index and see if you still get strage results. All else fails rebuild you indexes maybe?

I got it to work. The problem was with the index. I was indexing on str(co,2)+dist. The first field is 2 digit number and the second is a 4 character string. The problem was that the parent table's dist field was 6 characters instead of 4 this left me with trailing spaces that messed up the index. I trimmed off the spaces and everything works great now. Thanks for the suggestions and help.