Hi, I'm in waaay over my head. I know some basics, but I need a little help to move forward! This is a "Cash Register" (Point of Service/POS), "Inventory", "Contacts", "Supplies", "Expenses", etc...
In POS Table, Style Code became a Lookup Column (did I do that?)
In Inventory Table, 8 records listed. Query of Inventory returns Record 1 and 7. ???
Last Name, Style Code and Description are not correct. I have a relationship under the Style Code & Desc, and I'm not allowed to change these controls (can do it thru relationships?) I've been hurting my brain over this, for hourssssss! Thank you!!
In regards to Inventory, I would like the Primary Key, Style Code be decreased by number (Qty) field in the Inventory Table, and have it create new Field "SOLD". In other words, as the QTY on the POS Table decreases, it should reflect on the Inventory Table.... BUT no relationship the other way around (can add into Inventory Form, but do not have it add to any POS data.
ANY guidance is greatly appreciated!!!