I am trying to put together a database to track both invoicing and payroll for a small business. Things have gotten a little too complicated for Excel to keep up with easily.
I've spent several weeks taking a crash course from Google University, and I think I have the basic tables I need put together. However, I'm having some trouble setting up the appropriate relationships and data entry behaviors in Access.
I would like to be able to:
At this point I'm hung up on being able to assign an employee billing rate to a line item. I've managed to assign an employee to a line item, but I can't add that extra relationship to my form.
I think the next part will be fairly easy to work out once the above is setup, but the big picture goal is to be able to:
Thanks in advance for the help!!
EDIT: I attached a simplified diagram of what I think the tables and relationships should look like.
I've spent several weeks taking a crash course from Google University, and I think I have the basic tables I need put together. However, I'm having some trouble setting up the appropriate relationships and data entry behaviors in Access.
I would like to be able to:
- Create a project (Done)
- Add separate line items for specific sub-projects (Done)
- Then assign some employees to those line items
- Select from that employee's available billing rates to use for that specific PO line item.
At this point I'm hung up on being able to assign an employee billing rate to a line item. I've managed to assign an employee to a line item, but I can't add that extra relationship to my form.
I think the next part will be fairly easy to work out once the above is setup, but the big picture goal is to be able to:
- Import our weekly timesheet info (I can do this)
- Calculate dollars spent for each PO line item (I think I can do this once the above is sorted out)
- Create Invoices (I'm not there yet )
Thanks in advance for the help!!
EDIT: I attached a simplified diagram of what I think the tables and relationships should look like.