Inventory Database & Sales Records Help Needed
I'm new to FM Pro and am attempting to build myself an inventory system for my online resale business.
I've downloaded FM Pro and have read the entire FM Pro Tutorial, so I have a basic understanding of how the program works.
I have managed to create a basic inventroy database for myself, and it is working great so far. I can enter items to my inventory as they are puchased with description, etc.
Where I am stuck is that I want to be able to "mark" these items as sold in my inventory database, which would somehow activate fields where I could enter the sales information (price, date, etc) for that particular inventory item, and subsequently remove that item from my active inventory and put it in a "sales record" list of some sort.
I'm just wondering if this is at all possible, and if so could someone help me with the steps involved in doing this?
Any help would be greatly appreciated.