Hello all,
I am attempting to create a custom point-of-sale system for a pizza shop using MS access. I am by no means a professional programmer, so please forgive my ignorance...
The data that I will be working with is:
Inventory Items - everything in its most basic form as ordered from the distributor. Includes raw ingredients such as salt and pepper, paper goods like boxes and napkins, and items like green peppers and onions that can be an ingredient by themselves, or used in combination with other inventory items to make ingredients like sauces.
Ingredients - Items used to make products. Some items will be the same as an inventory item like onions and peppers. Some will be made of multiple inventory items. For example the ingredient garlic butter would be made of the inventory items garlic powder, butter, and oregano.
Products - These are to be comprised of ingredients and assigned a price. This will be the table day-to-day users will work with the most as it will be used to record sales and track inventory.
The objective is to interrelate all these items so that I can work with them to keep track of sales and inventory. I'd like to be able to have a form where a button is linked to a specific product (POS screen). Adding said product to an order and processing will deduct the appropriate amounts from each related inventory item's on hand count, record to a sales log, and update the balance of the cash drawer.
The part where I'm having the most difficulty is in structuring the tables, especially with inventory, ingredients and products. Do I need to have a separate table for each ingredient and product as the number of inventory items and ingredients will vary? If so is it necessary or even useful to have a master list of products and ingredients? How would a pro set this up?
Am I in over my head?
Any ideas and info would be greatly appreciated.
Thanks!
Josh
I am attempting to create a custom point-of-sale system for a pizza shop using MS access. I am by no means a professional programmer, so please forgive my ignorance...
The data that I will be working with is:
Inventory Items - everything in its most basic form as ordered from the distributor. Includes raw ingredients such as salt and pepper, paper goods like boxes and napkins, and items like green peppers and onions that can be an ingredient by themselves, or used in combination with other inventory items to make ingredients like sauces.
Ingredients - Items used to make products. Some items will be the same as an inventory item like onions and peppers. Some will be made of multiple inventory items. For example the ingredient garlic butter would be made of the inventory items garlic powder, butter, and oregano.
Products - These are to be comprised of ingredients and assigned a price. This will be the table day-to-day users will work with the most as it will be used to record sales and track inventory.
The objective is to interrelate all these items so that I can work with them to keep track of sales and inventory. I'd like to be able to have a form where a button is linked to a specific product (POS screen). Adding said product to an order and processing will deduct the appropriate amounts from each related inventory item's on hand count, record to a sales log, and update the balance of the cash drawer.
The part where I'm having the most difficulty is in structuring the tables, especially with inventory, ingredients and products. Do I need to have a separate table for each ingredient and product as the number of inventory items and ingredients will vary? If so is it necessary or even useful to have a master list of products and ingredients? How would a pro set this up?
Am I in over my head?
Any ideas and info would be greatly appreciated.
Thanks!
Josh
Comment