Relationship with 2 dates

[KeithYoung5]

Hi,

I have a large database that tracks the jobs of a transport company. Each job has a collection and a delivery date. I need to create a layout (on screen and to print) that shows the record that match a specified date, like to day.

The point is that by looking at that layout you can see all jobs where they are either being collected or delivered on that date, or say tomorrow.

So far I'm a bit stuck, can anyone help.

[RalphL]

You could do an OR find for the 2 dates and display the result in a columar/report layout.

[KeithYoung5]

Can you be a bit more specific. At the moment i use a relationahip and a portal to display all jobs that are current, is it possible to create a portal to view the records for the date specified (as in today)

Thanks

[RalphL]

Yes it is posible but you need an OR relationship. You can use a list of the 2 dates, i.e,

Collection Date

Delivery Date

were they are separated by a return.

This would require a calculation = Collection Date & "P" & Delivery Date. The P represents the return. This a text calculation. On the other side of the relationship you need a text field = date. You may have to use GetAsNumber function.

I sugested the the other method since you said you want to print a report. A script something like this should give you both.

Go to Layout (Report) /* this is in table with data */

Enter Find Mode

Set Field [Collection Date; Get (CurrentDate)]

New Request

Set Field [Delivery Date; Get (CurrentDate)]

Preform Find

Edited August 31, 2005 by Guest