This is a simple online database program for a company that sells boots.
I have a basic version of this app in Google apps here: [url removed, login to view]
I want to expand on that, and be able to track inventory of boots that I sell. I want to be able to input my entire stock of boots, and update it whenever I have new inventory that arrives. I also want to track (as you see in the app I already have) all the boots that are sold. I want all boots sold to be subtracted from the inventory, so at any time I can know how many pairs of boots I have in stock, of each style and each size. I want to be able to sort everything by size, style, or both. I want to be able to print how many boots I have at any given time, and have a breakdown of everything I have by size and style. I also want to be able to print how many boots I have sold by day, week, or year. I want to be able to print how many boots have been sold by a specific salesperson, or by specific size, or size and style, etc. Basically I want all the data to be organized by any variable.
I also want people to have to login this database, with three separate permissions:
1)Master account--Can View, add data, modify data, access to everything
2)Secondary account--Can View, add data, but NOT modify data.
3)Tertiary account--Can Add data, but NOT view or modify data.
I want to be able to edit this whenever I need, so if I get more styles of boots in the future I can easily add them into the database myself.