How do I collect sales data upon enter
I own a vending business. When I service a machine I want to be able to save the collected dollar amount and save the date and amount into another table so I have this data to run historical sales. I want to be able to track sales figures by location as well as sales trends by date. I am sure I need to create another table but I am clueless as to what to do next. I have one table right now with all my data for each location stored. Where do I start?
Any help appreciated.