Schedule Conflict

[Jaren Meier]

I know there are alot of posts out there for calendars and even schedules. What I am looking for is some help in multiple dates per record, placed into a simple weekly schedule. Sort of like a job that gets done in parts through out the week or weeks. I cannot get a script to recognize the multiple repetitions for each record. Only the first repitition is show. Please help.

[Ender]

It would help to know more about your structure and script.

But in general, it's better to use a related table if the number of elements (dates in your case) is not static, or if there may be more than a few. Repeating fields can be useful in some situations, but it's not clear if this is one of them.

[Jaren Meier]

there is 1 field with 5 repititions per record. The account rep can specify the single date in the first repitition or multiple dates in the 5 total repititions they would like their job completed. Say they have a 10,000 piece job to print, and they wanted 2500 pieces printed on 4 different days. It is still one record but with 4 differnt "print" dates. Right now the ticket is set with one due date. I need to show a schedule for the week or month so all departments can see the different days the rep scheduled the job.

[Ender]

This definitely looks like a good candidate for a related table (maybe call it "Job_Date"). Especially since it looks like the Number of Pieces could be stored in there with the Due Date, and maybe the Status of the job.

With a relationship from your current Job table to this new Job_Date table via the Job ID, you can use a portal to show and enter the Due Dates and other details. Then a simple Find in the Job_Date table for those Job_Dates whose Due Date is <= the current date with Status = "Open" or whatever, will show the list of jobs that are due along with the Number of Pieces.

Or, if you want to consider the job load of the existing Jobs when you go to schedule a new Job, you can use another relationship "Job_Date by Date (and maybe Department)" to get a portal showing those Jobs already scheduled for a selected date.

[Jaren Meier]

what about filemaker 6 that i will need to eventually convert to ver 7 or 8?? any ideas

[Ender]

Same deal. Use multiple files in place of multiple tables.