am about to do an access database that will store
information about projects, so far i can visualise a
client table(client id(p.k..), client name, address etc, a
project table(proj id(p.k.) client id(f.k.) proj name,
proj type, proj start date etc. Then i have to record the
amount of time spent by our emlpoyees each month on the
various projects, there are two groups a and b, and i also
have to record all invoices received each month for each
project. How do you thinki should do this?
Do you reckon:
a) have a 'Month' table with entries for each project for
each month - this ends up with a load of repeating fields.
b) have a new table for each month-this will result in a
load of tables.
c) Have separate tables for group a, group b and for the
invoice entries?