Table design for forms?

[orange]

Sounds like a work around.

Each job is assigned a batch

In 2-3 lines plain English -- what exactly is a Job? What exactly is a Batch?

What is the rule?

A Batch may have 1 or many Jobs
A Job is assigned to a Batch

[Homegrownandy]

A job is a period of time for an engineer to carry out his tasks on an asset.
A batch is a group of jobs (usually 100) which would be processed together. Batch is just to separate large scale projects into more manageable projects.

the current project has 3 batches with around 100 jobs in each.

As a definition the job is only the one day the engineer is on site. That IS the job. But that involves a lot of paperwork before and after.


another example: *these project names are for the purpose of the example.

"Current project" "batch 1"
"Current project" "batch 2"
"previous project" "batch 1"
"Previous project" "batch 2"

I may want to deal with information from all 4 of these as they are. Alternatively I may wish to deal with all of the current project. (both batches.)

[orange]

Hmmm...

This may be an issue:

A job is a period of time for an engineer to carry out his tasks on an asset.

That sounds like "duration" or "allocated time".

Isn't the JOB really the combined collection of tasks (that the engineer will perform on the asset).
And "duration (the time allotment/schedule)" just an attribute of the Job?

Merriam webster (M-W.com): JOB
: the work that a person does regularly in order to earn money
: a duty, task, or function that someone or something has
: something that requires very great effort



I'm not trying to be picky. I'm trying to show that detail is important.

Perhaps a Job has tasks such as
-initial paper work
-get plan approved
-do the work
-complete the paperwork
-get sign off

and each task would/could have a duration (time allotment).

Just saying that what makes a Job a Job and a Task a Task an what makes them different can be extremely important.