We use Romac for production control, inventory and purchase orders for material.
There is actually a series of programs you run depending on what you want to do.
Inventory Control, Production Control, Purchase Orders.
Each workstation contains the various programs and these programs access various data bases located in a NAS device attached to the network. We use a NAS, but the data files could be located on one of the workstations if we wished.
We are a steel fabrication shop. Each job consists of unique drawings showing what is to be fabricated. The data from the drawings is entered into the system so we can know what material to purchase and how to cut the pieces from the raw material we need. The program also tracks production of the pieces through production.
The program opens various data files depending on what you are doing and locks them out so no one else can access them until you are finished.
It's pretty specific though. More than one person can have a particular job open, but no two can look at the data for the same drawing. More than one person can look at inventory item, but they can not have the same inventory item open to modify. They can look at the same inventory item, but the others will have a message noting it's read only.
I don't know all the inner workings of the program, but I know it creates some small "lock type file" that the program looks for to determine if someone else has a specific data file open.
Let me know if there is anything I can look into
I really appreciate the help.