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

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
Sign in to follow this  


Important Information

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