>>>>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?
Roxanne M. Seibert
Independent Consultant, VFP MCP
Code Monkey Like Fritos