3 databases: one with inventory items that are serialized, another db to keep track of the inventory items that appear in a shipping/receiving database.
The shipping/receiving database will log all receipts and shipments of the items. Items may be received, shipped, and received in again, all recorded on individual records. Multiple items can be received at a time.
The items database needs to link to the ship/recv database so a history of each item can be obtained.
A script is then run to print a report of real time inventory (a serialized item that is received is considered in inventory; an item that is shipped has a location field updated as to where it was shipped.)
I'm looking for someone to set up the relationships; the rest of the reporting, scripting, layouts can be done in-house.
Thanks