Create an Inventory DB with Serial Number tracking
We're trying to create an inventory database that will track the full lifecycle of a piece of equipment from purchase through sale, return and resale. These items have a specific serial number that we need to track them based on for invoicing, and set up information .
I was able to find the link below which was helpful - but doesn't quite get us the whole way.
Any help or direction anyone has would be great!
You might want to treat your sale of the equipment like the "loan" of an asset.
If you are using FileMaker 11, 12, or 13, there is an asset tracking or Asset starter solution that comes with your copy of Filemaker that you can open and examine for ideas.