Jump to content

Schedule Conflict


Jaren Meier
 Share

This topic is 5746 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5746 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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