Can I have multiple field inputs for a single job?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I know this is probably simple but I can't seem to figure it out. I have a table for jobs and estimates. One of the fields for a job is a multiple choice field "Type of work codes" where the user selects a code number from a list. Sometimes a single job will have multiple work codes due to the different types of work they may be doing. How can I allow the user to choose multiple work codes for a single job?

Photo of Brandon

Brandon

  • 120 Points 100 badge 2x thumb

Posted 4 years ago

  • 0
  • 1
You will need to create a middle join table of Job Work Codes.

One will have Many Job Work Codes.
one Work Code will have Many Job Work Codes.

Put the Report Link field of the Job Work Codes on the Jibs table and show the report records right on the form.