>>>>I am creating several cursors and am trying to relate them together. The first cursor contains name, address, etc. Then I create 12 cursors(1 for each month) that contain claim information(counts and dollar amounts) for each district. I index each of the 12 on str(co,2)+dist and then select the first cursor and do a SET RELATION TO str(co,2)+dist INTO cursorname ADDITIVE. When I run my report I get all 0's. If I browse the first cursor and then open up browse windows for a few of the months cursors I get some weird behaviour. The month cursors flicker, show the correct data for a second and then going blank. What am I doing wrong? This is in FoxPro 2.6 if it makes a difference.
>>>>
>>>>Shane Gilbert
>>>>OK SDE
>>>
>>>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.