I help at an non profit auction each year with about 400 to 1000 items. I need to create a File Maker Program to allow us to enter and track multiple items with categories, the donor information, bidder information, a screen to enter the winning bidder of the item, and multiply checkouts. All these items must be in a relationship with each other.
The work flow would be to register “bidders”, “donors”, and list the “items”. On the night of the auction as bids close I need to be able to go to a layout screen and enter the item number, bidder’s number and the amount of the winning bid. On the checkout tab(s) when you enter the bidders number all the items that they won populate and total with their name and address etc. I will then need to print a receipt.
Also I would like a table for sponsors too, but there is no relationship to other tables.
A year ago I started the front end of what I wanted this to look like but never finished it. I would like a third checkout tab and a summary tab added (number of items, items value, number of bidders, total bid, etc.) For the last year I used a google sheet program which worked but really wasn’t perfect, I really need something more reliable. Another feature to be considered is importing and exporting the data to Excel. I can be more specific after we get the program working correctly. I will be running this in File Maker version13 peer to peer.
I will be needing some reports other than the printing of a receipt from the checkout