rdhaden Posted January 31, 2005 Share Posted January 31, 2005 Anybody else making databases of events? How are you handling dates, particularly multiple dates? For example, a concert may hold two weeks of dates until the tour solidifies and they settle on one particular date. Or a basketball tournament may occur across three days. Thus multiple dates per event. In 5, I had date as a repeating field, but that has obvious limitations, first being the number of dates an event can have is limited to the number of repetitions the field has. In 7, since I can have multiple tables in a single file, I thought I'd make Events one table and Dates another, with the Dates table having EventID as a foreign key. Sounds good. I can have unlimited number of dates per event, unlimited number of events per date. But... I want context-sensitive calendars (i.e., a calendar that only shows events that use a particular room, or only confirmed events, not tentative, etc.) Since calendars are really portals for each day, I match left side globals set by script, right side date. But for context, the match has to contain info from both tables (space used or status in Events table, date in Dates table). But you can't index a calculation that references related fields. Any suggestions? Link to comment Share on other sites More sharing options...
This topic is 6633 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
Already have an account? Sign in here.Sign In Now