solutions wanted Calendars and Scheduling

[mandikcool1]

I am working on a database that schedules a complete 1-year life cycle of our marketing campaigns. Each week has a particular step captured with it. There are multiple weeks where the date must fall on a predetermined meeting date, so I have set up master calendars for all of these meetings. My master 52-week schedule has a series of 52 date fields, one for each week of the year. For the weeks that are pre-defined, I have inserted calculations into the field that goes to the related meeting table and picks the next available meeting date, and then backflows the remaining steps from there. All of this is working great - I have a milestone view that pulls a report of the high-level milestones. All the meeting dates are flowing correctly. Each marketing "job" has it's own record, and is based on a manually input launch date, which starts backflowing the whole schedule.

NOW, I have been asked if it is possible to link the milestones (less than 10 steps/weeks) from the master schedule and outline them on an actual calendar view. I have found samples of only a calendar function, where you input scheduled events onto calendar days, but I have not been successful in finding something similar to what I need to do. Basically, I want to link the dates from the milestones I choose in each job, and show a high-level overview (job name, milestone due) on the related date in the calendar.

Any suggestions!?? I am a self-taught FMP user, working in 8.5.

[Vaughan]

What you are doing is complex and would not be easy to work out through a Forum.

I don;t know what the problem is but it sounds like a data structure issue...

"My master 52-week schedule has a series of 52 date fields, one for each week of the year."

It might have been better doing this relationally: a "Schedule" record related to 52 "week" records, which in turn relate to the "job" records. This structure might give you the flexibility that you need.

It'd sure beat having to make 52 different relationships between the Schedule table and the Jobs table.

[Twd70]

I agree with Vaughan, definitely sounds like bad structure.

I have created my own calendar in Filemaker, which we currently use for 1 of our solutions.

Contact me / send me a file if you need help on this. As I think a look at your schema is required.