Hi guys,
I need help creating a calendar in Access 2007 for the kitchen improvement company I've just started working for. I need a main calendar then one for each of the ten employees. If I change any information for an appointment on the main calendar it has to change the information on the corresponding employees calendar and vice versa.
I thought about creating a database for customer information with a customerID and linking that to all the calendars but that seemed like unnecessary work. It would mean I'd have to update the customer database then the calendar. Most customers will only use us once so there is no real point in keeping their details. I then thought about doing an Employee database with an employeeID but then couldn't work out how this would help me.
If any one could help I would greatly appreciate it. If possible please try to make things as simple as possible.
Thanks
I need help creating a calendar in Access 2007 for the kitchen improvement company I've just started working for. I need a main calendar then one for each of the ten employees. If I change any information for an appointment on the main calendar it has to change the information on the corresponding employees calendar and vice versa.
I thought about creating a database for customer information with a customerID and linking that to all the calendars but that seemed like unnecessary work. It would mean I'd have to update the customer database then the calendar. Most customers will only use us once so there is no real point in keeping their details. I then thought about doing an Employee database with an employeeID but then couldn't work out how this would help me.
If any one could help I would greatly appreciate it. If possible please try to make things as simple as possible.
Thanks