>>Hello All,
>>I have a Jobs.Dbf (one row per job) with a one-to-many relationship into JobParts.Dbf
>>
>>The production process is semi-automated with machines that can receive/take parts simultaneously from several sources (feeds), for example: conveyor belts, mini gantries, collection bins, etc.
>>
>>Operators are spending too much time managing the manual part of the process: supplying parts to the various feeds. Each time a change of part is required the whole process has to stop. Ideally I would like to queue the jobs so that transitions in the Part Feeds are minimized.
>>
>>Any ideas appreciated
>>Pete.


>I am not sure if I understood your problem. As long as jobparts.dbf is opened in SHARED mode from each workstation (Feed centers), you should be able to insert data at the same time.

Jayesh, thanks for the response. It looks like I did not state my problem very clearly. Gerry Schmitz has clarified things in his response. The main challenge is sorting the unfulfilled job orders (in Jobs.Dbf) so that they minimize transitions in Part feeds. Please see Gerry's response for more detail.
Pete.