Job Queue I have a customer table with all the necessary fields that I need for a Job Card where the customer and job records are kept. However, I need to track which customers job is next in the queue, and where to put the job when it is put to one side for paint to dry or parts need to be ordered etc.
I think a Function is what I need, but don�t know how to do it in A5v6 :-
Example: A particular train was brought in (call it job A-123) this morning and is queued for #12 (just for tracking the job in this example). Later that afternoon you finished a paint job (call it B-456) in #4 position that needs to wait for paint to dry and you pull it from it�s #4 queue. The �Function� will recognize the fact that the #4 position is open and bump the list up one with out any other user input. Our job A-123 would be bumped up to the #11 queue and all queues in front and behind it up to the #4 position would also bump up one. Queue's #1, #2, and #3 would stay the same. You then assign another position (lets say #7) to the B-456 job that is waiting for paint to dry. The �Function� will then automatically bump every thing ONLY later than #7 back one to #8 and so on. Our original job (A-123) that was brought in today that had just been bump up the #11 position would now be kicked back to its original #12 queue. There would be no limit to how high the queue went and it would be generated automatically as the "Function" would automatically know if it needs to add or subtract "1" from the queue. The outgoing result would need to be a correct queue # based on the current status of the table. Only the queue number would change and be re-indexed so all of the original notes would remain for the ID on that job.
Please can someone help me.
Ant-Tech
I think a Function is what I need, but don�t know how to do it in A5v6 :-
Example: A particular train was brought in (call it job A-123) this morning and is queued for #12 (just for tracking the job in this example). Later that afternoon you finished a paint job (call it B-456) in #4 position that needs to wait for paint to dry and you pull it from it�s #4 queue. The �Function� will recognize the fact that the #4 position is open and bump the list up one with out any other user input. Our job A-123 would be bumped up to the #11 queue and all queues in front and behind it up to the #4 position would also bump up one. Queue's #1, #2, and #3 would stay the same. You then assign another position (lets say #7) to the B-456 job that is waiting for paint to dry. The �Function� will then automatically bump every thing ONLY later than #7 back one to #8 and so on. Our original job (A-123) that was brought in today that had just been bump up the #11 position would now be kicked back to its original #12 queue. There would be no limit to how high the queue went and it would be generated automatically as the "Function" would automatically know if it needs to add or subtract "1" from the queue. The outgoing result would need to be a correct queue # based on the current status of the table. Only the queue number would change and be re-indexed so all of the original notes would remain for the ID on that job.
Please can someone help me.
Ant-Tech
Comment