Relationship to date range

[johnrh]

I am sure i have done this before - but somewhere my mind has lost a cog (or two)

I am using Fm7 and I a need a relationship to show training seminars for paricular months.

My parent file contains contains two global fields (gMonth and gYear)

My child file contains seminar details (Title, start date, end date, details etc.)

I need a portal to show all seminars for that particular month so that as the use changes the parent's month and year so the portal changes to reflect the seminars active during that month/year.

As an example say, gmonth = 09 (September) and gYear = 2004

There are obviously a number of choices - Seminars that

- start in August and end in Sep

- start in sept and end in Sept

- start in Sept and end in Oct (or later)

- sart before sept and and after sept

I can extract the month and year parts out of startdate and enddate fields

It is just that I cannot think of the relationship required.

This is really important so please please can anyone help. As I say I am using FM ver7.

Thanks everyone

[The Shadow]

Here's one that does it, the key part is that you need calculations to convert the month/year into dates, so you can compare them directly against the seminar dates.