hi expertse... i want to create a database for my shop. Please help me. I want to create a database to keep record of sales, payments to suppliers, staff paidouts etc... problem is we got people working in various shifts. currently everytime cashier finishes his/her shif, they simply take the till readings. and the till readings contain the necessary info, such as credit card payments, chq payments, paidouts etc... i got following tables: daily(daily id, daily date,till reading, cash, credit card, chq etc), Payments(Payments ID, Daily Date, Supplier ID, Amount etc). i want each till readings data to store as individual, instead of combing all the data with date order. THAS WHAT HAPPINING AT THE MOMENT. please help... thank you so much guys...