Jump to content

Create a table of empty records


This topic is 5664 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

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 by Guest
Link to comment
Share on other sites

This topic is 5664 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.