>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?