janet K Posted November 13, 2007 Share Posted November 13, 2007 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 More sharing options...
Søren Dyhr Posted November 13, 2007 Share Posted November 13, 2007 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 More sharing options...
Recommended Posts
This topic is 6143 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 accountSign in
Already have an account? Sign in here.
Sign In Now