Today, CurrentDate, Relationships...

[Jerremy]

Hi all,

I'm having some trouble with a scheduling system I've created.

Currently, the system uses a 'Start" date and an 'End' date. If the Start date has not been reached yet, my calc field will create the date range from Start to End. Example, (Start) 1/1/2002 - End(1/5/2002) will give me:

1/1/2002

1/2/2002

1/3/2002

1/4/2002

1/5/2002

But, if we are past the start date, I have the calc use Today to the End date. So if today is 1/3/2002, my calc gives me:

1/3/2002

1/4/2002

1/5/2002

I'd like to eliminate the Today function and use the Status(CurrentDate) as many people have suggested in the forum. This needs to be an unsorted calc, which brings me to my problem.

In my related file, The Schedule Calendar (which is set up as a week is listed per record), I have data listed via a portal under each day.

Basically, when we hit the next day, I need the previous day to be removed from the range, which removes that days data from the Calendar.

My relationship breaks because my calc is now unsorted.

Is there any way around this, or am I stuck with the Today function? I know I can, and have, used the recalc today AppleScript, and that I can open and close the database from Server, but I'd like to not have to do this anymore.

Any ideas?

Thanks for your help.

Jerremy