Inserting a row into a list

[Andy Williams]

I'm working on a manufacturing scheduling program, and I'm looking for a
table design to accommodate the following:

Let's say that I have a list of jobs, in no particular order. I need to be
able to assign each job a date to be run. Simple enough. But, I also need
to be able to specify the order in which the jobs are run. I could do this
using a sequential number field, but what do I do when the schedule changes
and I need to insert a job or bump other jobs out.

Any ideas would be appreciated. I'm working with a completely clean slate
right now, so I'm open to any suggestions.

Thanks in advance!

 

[Duane Hookom]

I would create a Job Schedule table with the primary key from the Job table
as well as a schedule date field and a sequence field. You can then create a
form with this information and edit the data how ever you please.

 

[Jeff Boyce]

Andy

It might be a bit of a kludge, but your "sequence numbers" only need to be
sequential, not consecutive. If you use 10, 20, 30, ... for sequence
numbers, you could always "insert" a new job with a sequence number of 15,
and then another with 12, and one with 18.

If your occasional schedule changes are more regular, start with 100, 200,
300, ... instead.

Good luck!

Jeff Boyce
<Access MVP>

 

[Adrian Jansen]

Use the full capability of the Date/Time field. Insert the job at the
correct date/time. Then to change the order, just change the Date/time to
before/after other jobs in the sequence.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control