Newbies LoveFaithSwing Posted July 16, 2007 Newbies Share Posted July 16, 2007 Hi, I am fairly new to FileMaker and am programing a to-do type database. I am trying to figure out how to set up the relationships between my tasks and when I do the tasks. Here is my problem. I have a table with tasks which includes taskID and other specific task data. I want to be able to link a task to a day, but want the option of setting the time or not. It sounds easy, but the catch is that I want the specific worktimes to be pre-defined (I set the times on specific days that I want to work and then assign the task to those worktimes). If I have more tasks then I can accomplish in my worktimes, the extra tasks will be assigned to a day generically (without a time). Also, I need it so that a task can be assigned to many worktimes. (therefore a many to many relationship) I tried setting it up so that I have my tasks table, a worktime table, a calendar table, and a separate table to use to make the many to many relationship. Is this the best way to do this? How do I set up my separate table so that I use either a worktime OR a calendar date? Thx!! Hailey Link to comment Share on other sites More sharing options...
bcooney Posted July 17, 2007 Share Posted July 17, 2007 go to John Mark's site and search files for "Calendar." A calendar is a challenging project for a new user, best of luck. www.databasepros.com Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6128 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