Need some help on design...

[jeff907]

Hello, I am new to Access. I have built a database for some aspects of my work in construction, but I have to make one for Job Budgets which I am not sure how to design.
Could anyone give me some guidance?

Main Table:
Job Budget (Job#, Job Name, Cost Code, Cost Code Description, Labor Hours)
I want to create a budget here on this table for a job. The job budget could use anywhere from 5 to all 50 of the cost codes and each cost code would have a number associated for labor hours.

Example:

Job# 29920
Job Name: Facility Maintenance

38950 - Demolition - 24 Hours
38640 - Other Repairs - 8 Hours
38290 - Utility Testing - 12 Hours

Reference Tables:
Job List (Job#, Name)


Cost Code List (cost code, description) about 50 or so cost codes


I don't know if I should design the Job Budget with a field for each of the cost codes, spanning across all 50 or so of the codes and enter hours under the codes. The problem there is that there will likely be nothing inputted under many of the cost codes, only a few for each job and it would possibly take up too much screen space.

Otherwise, I am wondering how to design the Job Budget with just the ID (auto number), Job Number, Job Name, Cost Code and Hours - but allow for multiple cost code entries referenced under one job.

I hope this makes sense, but I am a bit confused being new...

Thank you,
Jeff

[orange]

Suggest you step back and describe - in plain, simple English (no jargon) -- a day in the life of your business.
It will help readers understand your set up and your business.
Start at the 30,000 ft level and gradually add some details.
Good luck.