Form design question

[m_elect]

I want to build a form for a 'job' that contains a daily status, the employees who worked on the job and their hours. I know that the daily status part should be a sub form but how should I include the employees and their hours?

Thanks.

 

[pbaldy]

Depends on your table structure, but it sounds like employees and hours would be a subform.

 

[m_elect]

Depends on your table structure, but it sounds like employees and hours would be a subform.

Thanks. So the employees and hours would be a subform to the status subform?

 

[pbaldy]

Again, depends on your table structure. My suspicion would be that both would be subforms to the job. I only see status as a subform if it's in a different table. Typically status would be a field in the job table, but I can see it as a separate table/subform if you store the history of status changes to a job.