Hello All,
I'm new to this site and relatively new to Access. I am in the process of creating a new database and need some advice about how to go about creating my tables. I would appreciate very much thoughts any of you may have:
The database will be used to track important "milestones" that occur in matters that my employer handles. Basically, each customer of ours has 12 milestones that occur during the course of my employer providing its services.
I need a way to track how far along each matter is at any point in time.
What I am trying to accomplish is:
1. add new customer's info
2. automatically have the 12 milestones already listed for this new customer
3. as time goes on and more of the milestones are completed, I will check them off
So....each customer has 12 milestones, some customers have more milestones completed than others.