relating a months table

[knewt99]

Please help if you know what relationship I need to build to do the following:

My Contracts table has a month field and a dollar amount field.

I need the data to display in columns with all the Jan amounts in column 1, all Feb in column 2 and so on. In other words, the 12 months of the year across the top and dollar amount for each contract in that month listed below, with a total at the bottom of each column.

Jan | Feb

400 | 600

250 | 350

___ | ____

650 | 950

I may be having a daft moment here but I can't figure out how to do this. Thanks for any ideas.

Edited March 6, 2006 by Guest

[Razumovsky]

Hi Knewt,

I used to do this using 12 relationships from 12 globals populated with the 12 months (gJan, gFeb, gMar...), or a related months file with 12 records, one for each month. Then use 12 portals across the top. A bit cumbersome, but it works. I hope there is a more elegant way to do this in FM7/8 but havent tackled it yet. You might try browsing some new calendar DBs that are around and see if it gives any ideas...

HTH

-Raz

[knewt99]

Thanks Raz,

I'll try both those methods and see what works best. No one seemed to have any better ideas.

Knewt