Filtering 1/2 hour increments of a day

[JFMiller3]

Before I dive into creating 48 separate relationships and a layout to show this compilation of data, does anyone know a quicker way to do this?

 

At this time I have a scheduling system to show a listing of truck loads on any given day. The Schduled Date is related to a global date field. This filtering systems works extremely well to show the the loads in in a portal sorted by time. Now they want to show timeslots in half hour increments. They want to show the timeslot even if there are no truck loads in that slot.

 

Any thoughts would help. I need to think in another more efficient direction.

[mfif]

You could insert an intermediate filtering table with just 48 records, one for each time slot, and show a portal of that. Watch out for overlaps, though - and it might be a good idea to have a start-up script or at least a debugging script that checks to make sure there are only 48 records and they're set at the right intervals.

[JFMiller3]

Thanks -

 

That got me in the right direction.