Create a table of empty records

[Kevin Cheesman]

In MS Access I had a routine to create a table of records. 2 records for each day between two dates I specified. One record was marked AM and one was marked PM. These were linked to a bookings table and the empty records showed as AM or PM slots that we could book as appointments. This method was very clear when the table was printed or displayed on the screen, showing free and booked dates in date order.

Is there a facility in FileMaker to do this, or is there a better way of displaying free, unbooked dates?

[Ender]

Sure this can be done. See this thread for some discussion about a couple different methods for generating records for a similar solution:

http://www.fmforums.com/forum/showtopic.php?tid/176396/

I think there's a demo from John (near the end of the thread) showing the differences.

Edited May 25, 2006 by Guest

[Kevin Cheesman]

Thanks for that!