Feeling silly here - after creating a rather complex database that you guys helped with - this task seems simple... yet I am drawing a total blank.
I have a new project - building a database for a salon to keep up with customers and product sales.
Have a sales form which is truly only for inventory control, so
The form data is attached to a table named SalesTracker.
It has the following fields:
TransactionID <PrimaryKey>
SoldTo <uses combo box attached to Customers table, one column>
ItemName <uses combo box attached to Inventory table - 4 columns, ItemID, ItemName, ItemPrice & ItemsOnHand>
ItemsOnHand <pulls ItemsOnHand out of ItemName combo box column 3>
ItemPrice <pulls ItemPrice out of ItemName Combo box column 2>
QuantitySold <User input required>
SaleAmount <Calcuated using cmd button>
When the cmd button for calculate is pressed, I want to do the following:
sum the order using ItemPrice *QuantitySold (achieved this no problem)
update the ItemsOnHand field in the InventoryTable for the specific item by taking ItemsOnHand and subtracting QuantitySold value - got the math part... but drawing a blank when I go to update the Inventory Table for ItemID just sold.
Sorry, I am sure this is probably very simple... but its alluding me!
Sophie