I'm continuing a post that I had under Queries but it turns out it is a table issue.
Link to other post:http://www.access-programmers.co.uk/forums/showthread.php?p=1228190#post1228190
I have created 4 tables now
tblPOS
tblOpenClose
tblBartenders
tblBartenderTips
tblPOS has the following fields:
TransactionID, BusinessDate, Food Sales, Liquor Sales, Beer Sales, Daiquiri Sales, Wine Sales, T-Shirt Sales, Tax, Comp, Disc, Visa, American Express, Discover, Master Card, Cash Paid Out, Cash Paid In, Total Cash, Donations, Gift Certificates, Credit Card Tips
tblOpenClose has the following fields:
TransactionID, BusinessDate, Open Drawer, Close Drawer, Cash Tips, Open Bartender, Close Bartender, Number of Bartenders
tblBartenderTips has the following fields:
TransactionID, BusinessDate, EmployeeID, Amount
tblBartenders has the following fields:
EmployeeID, Name
I don't know if this is right or wrong or if it should be split up some more. I'm also unsure about the primary keys and relationships> Any pointers or direction will be greatly appreciated.
Link to other post:http://www.access-programmers.co.uk/forums/showthread.php?p=1228190#post1228190
I have created 4 tables now
tblPOS
tblOpenClose
tblBartenders
tblBartenderTips
tblPOS has the following fields:
TransactionID, BusinessDate, Food Sales, Liquor Sales, Beer Sales, Daiquiri Sales, Wine Sales, T-Shirt Sales, Tax, Comp, Disc, Visa, American Express, Discover, Master Card, Cash Paid Out, Cash Paid In, Total Cash, Donations, Gift Certificates, Credit Card Tips
tblOpenClose has the following fields:
TransactionID, BusinessDate, Open Drawer, Close Drawer, Cash Tips, Open Bartender, Close Bartender, Number of Bartenders
tblBartenderTips has the following fields:
TransactionID, BusinessDate, EmployeeID, Amount
tblBartenders has the following fields:
EmployeeID, Name
I don't know if this is right or wrong or if it should be split up some more. I'm also unsure about the primary keys and relationships> Any pointers or direction will be greatly appreciated.