Jump to content

Trouble with Multiple Dates


janet K

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

Recommended Posts

I am working on making a database for events that we get invited to. Some of them only happen once for one date, others are 3 or 4 days in a row, while others are all the weekends in october.

What is the best way to store this if someone wants to go in and put in a date or date range and find out all of the events that are happening for those dates.

Now that I am typing this I am thinking that the date and time should be in its own table? While the other event information is in anohter table.

Any suggestions would be greatly appreciated.

Link to comment
Share on other sites

First of do you know that join-tables can be omitted and be replaced with fields holding value's based mathematical expressions, and why and when to do so??

This really will take you deep into relational approaches a la Filemaker, and you could study this template where some measures in that direction is shown:

http://www.fmforums.com/forum/attachment.php?attid/7281/

...as well as recursive customfunctions - say like LeCate's CF here:

http://www.clevelandconsulting.com/support/viewtopic.php?t=739

--sd

Link to comment
Share on other sites

This topic is 6067 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
×
×
  • Create New...

Important Information

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