I have made about 5 different layouts on paper for my database, but still not setting it up correctly. I think I am making it to detailed for my own good.
I would like to get a minor push in the right direction. I am not asking for anyone to do my work, but a little nudge.
The database is going to be used to keep track of both overtime (we have 4 types of overtime) and people who are off on leave (we have about 10 different types of leave).
For the overtime staff I will need to have fields to include name, rank, location they work (dept) and number of hours. We use employee id numbers, so I will have an employee id field and have that with relationship to another table to fill in all the fields (I have made that work already).
Thanks in Advance
Mike