perhaps someone can help me with the following :

I have a global text field - g_Month - which is used in a relationship. It contains a value list of Month names. There is a button on either side of this field on the layout which is supposed to cycle through the month names -

How do I obtain the previous / next month's name ?

Many thanks in advance,

Kindest Regards

Glorifindal

It's not clear what you are asking. Are you trying to build this functionality or use it? Are you the developer?

PS: You have ranked yourself as Advanced. Many people confuse this setting with the fact that they are using FM Advanced.

It could perhaps be done this way? Provided I have read the sparingly spec's correctly?

--sd

switching.zip

That's exactly what I need - Many thanks Søren - I like this way of doing it indeed

Kindest Regards

Glorifindal

It would be a lot easier to calculate the first of the month (as a date) instead of the month's name. This has two advantages: (a) the year is included, and (: bumping a global date up or down a month is rather trivial. The global date field can be formatted to show only the month (or month and year, depending on the purpose).

The global date field can be formatted to show only the month (or month and year, depending on the purpose).

I did actually think about those lines, but the valuelist is the catching point... perhaps you can think of a way the dropdown won't show a series of dates instead of the names of the month?

--sd

I don't see the need for a value list or a drop-down - in my approach or in yours. But if required, the global could use a drop-down calendar, with auto-correction to the first of month of the selected date.

Well then I see something else:

I have a global text field - g_Month - which is used in a relationship. It contains a value list of Month names.

But if required, the global could use a drop-down calendar, with auto-correction to the first of month of the selected date.

Indeed behave, close ranks etc. LOL... but yes it usually how I do it as well. But here are the requirement made!

--sd

Edited April 8, 201015 yr by Guest

Well yes, he did say that - but I don't think it's necessary to have both arrows AND a drop-down with only 12 values. Of course, it's still possible with both methods - but my main point is that basing a relationship on month name alone will lump together records of February 2010, February 2009, etc.

Yes that's how I would do it and then use a calc'field to establish the upper range limit. But when did the drop down calender arrive was it by the arrival of fm8 or fm8.5 I could remember Shawn had some templates for fm7:

http://www.spf-15.com/fmExamples/

...his datepicker templates!

--sd

I don't remember either, but it doesn't matter - because, as you say, you could use a self-made date picker instead.