Jump to content
Sign in to follow this  

Either Or relationship problem

Recommended Posts


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?



Share this post

Link to post
Share on other sites

go to John Mark's site and search files for "Calendar." A calendar is a challenging project for a new user, best of luck.


Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

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