Hi there,
I'm trying to create a db for the 30+ staff here that lists their holiday entitlements: how much they originally had, how much they have left, and details of the time they're already taken ('from' and 'to' dates, type of leave, etc).
Has anyone ever done this before?
Looks like I just need to create a table for each person and put in the details - but as this means creating 30+ tables I was wondering if there's any way around this or a facility that I'm not aware of.
any comments gratefully received
)
thanks - dunstan orchard
I'm trying to create a db for the 30+ staff here that lists their holiday entitlements: how much they originally had, how much they have left, and details of the time they're already taken ('from' and 'to' dates, type of leave, etc).
Has anyone ever done this before?
Looks like I just need to create a table for each person and put in the details - but as this means creating 30+ tables I was wondering if there's any way around this or a facility that I'm not aware of.
any comments gratefully received
)thanks - dunstan orchard