How do I generate a table of dates?

[Kevin Cheesman]

I need to generate a table of dates to link to a booking table, so that I will be able to see what days are booked and what dates are still free. I need 2 records for eeach date (for AM and PM bookings)

How do I do this in FileMaker?

[2mike uk]

why not just have one record for each date and 2 fields ie am and pm otherwise you have to loop creating records with something like set field datex = datex + 1 for 2 records ; next iteration and so on.

regards

mike