Hi,
I am creating a new database to store information on Jobs. The criteria are;
A Job has a Job # and a Job Name
When allocating jobs, the job is broken down into Divisions. Each job has many Divisions e.g.
Job_Number: 101
Job Name: Remodel the Kitchen
Divisions: Carpenters, Plumers, Tilers...