Events Relationship

[johnrh]

I have a small program with just two tables to be used for traking when certain events like meetings take place.

A table called weeks showing the Week No and the Start and End date of that week, and an Events table which has the Title of the event and its Start and end Date.

Some of the events are single day, while others are multi-day events.

Can anyone help me with the relationship so that the events will show up in a portal in the right week.

Some events will span 2 different weeks and need to show up in both weeks.

My weeks all start on Monday

Thanks

John

[Søren Dyhr]

There are several ways to achieve this, perhaps a good start is this:

http://www.nightwing.com.au/FileMaker/demos7/demo705.html

--sd

[comment]

Try defining the relationship as:

Weeks::StartDate ≤ Events::EndDate

AND

Weeks::EndDate ≥ Events::StartDate

[Søren Dyhr]

Only there seems to be traces in orginal post of recurring events as well.

Here comes the pilcrow delimited keying in Rays template more to it's right, because just as well as they build can be strained again, to make provisions of say every second Thursday or such.

--sd