We are looking for somebody to come up with a database schema for a small packaging company. The company does not purchase materials other than consumables such as pallets etc, but is free issued all its materials. Materials come in the form of mill/master reels of flexible packaging materials which are slit/cut down to food packaging dimensions. Normally a full mill/ master reel is used on one job, however, sometimes it is necessary to either return the part mill/ master reel to stock or alternatively produce reels that are then put back into stock for call of by the customer at a later date.
Intention is use FileMaker Pro 17.