FM6 relationship issue

[Ninja]

Excuse the long winded problem:

I am trying to produce a file containing data on loan applications which are paid out. Each day additional deals are paid and this amount is totaled to show the total paid. However i need to create a figures page which can show the amount paid out each day.

Creating a relationship to the date is no problem. However i want to make a file which contains 31 records (one for each day of the month), but do not contain the month number, this should be specified by the user to correspond to the month they would like to view.

The obvious answer is to get them to enter it into a global field, however in FM6 you cannot create relationships with global fields (i don't know if this has changed with 7 or 8 and if the company get the software they would get one of those, but i have to demonstrate it in 6 at the moment!)

Does anyone have any idea how the user can define the month without having to type it into all of the 31 records?

Ta

[aaa]

Helo, Ninja.

31 record is not many and you can by script change Month field in all records.

One of example i attached.

31DayWithMonth.zip

[comment]

First, if you only need a static report, you can find the transactions for the month and sub-total them by day (showing sub-summary only, with no body part on the layout).

Second, you CAN use global (or otherwise unindexable) fields on the left (parent) side of the relationship. You can have a global field for the month, and each record can calculate its own date from that and the current year, e.g.

Date ( gMonth , SerialID , Year ( Status (CurrentDate) ) )

[Ninja]

I didn't think that global fields could be used in relationships atall.

I've tried it again and it works great.

Thanks for the help