>hello,
>
>thank you very much it works very well,
>
>if i want to return all this tables again to one table as table(allmonth2004). is that logic and possible.
Well, I think you should have one "official" table - probably the shared one - and then create other tables (the separate months) as needed, for reports.
Anyway, here is how you can combine it.
I will simply assume that all 12 months exist; if this isn't sure, you can use the file() function to check. The following is untested code.
i = 1
use ("Month"+ALLT(STR(I))+"2004")
copy structure to Combined
use Combined
FOR I=1 TO 12
APPEND FROM ("Month"+ALLT(STR(I))+"2004")
NEXT
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)