Hi need to design a database for work, not very good at it so need some help.
It's a fairly simple database with just one table needed at the moment. It involves customers loaning an item (which has 3 variants in sizes) and sometimes they will return them so I need two columns (one for items returned, one for items remaining)
After the usual columns such as address/name ill have:
Bottle 1|Bottle 2|Bottle 3|Deposit Paid|Bottles Returned|Bottles Remaining|
So if a customer loans 2 of each then returns 1 x bottle1 and 1 x bottle2 I want to know the amounts returned and amounts remaining.
It would be good if I knew how much of each type he returned and how much remains.
How would I do this in access, would I need multiple tables?
It's a fairly simple database with just one table needed at the moment. It involves customers loaning an item (which has 3 variants in sizes) and sometimes they will return them so I need two columns (one for items returned, one for items remaining)
After the usual columns such as address/name ill have:
Bottle 1|Bottle 2|Bottle 3|Deposit Paid|Bottles Returned|Bottles Remaining|
So if a customer loans 2 of each then returns 1 x bottle1 and 1 x bottle2 I want to know the amounts returned and amounts remaining.
It would be good if I knew how much of each type he returned and how much remains.
How would I do this in access, would I need multiple tables?