Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

Relate one Applicant to numerous Jobs

I have an app that will list available job openings (in a "Positions" table) and request applicants to apply.  Currently - when they apply - the app will open the add new record form in the "Applicant...
App builders
Ask about Quickbase functionality
Forms
AlexWilkinson's avatar
AlexWilkinson
Qrew Assistant Captain
8 years ago
Well, three tables, actually, which together create a many to many relationship.
  1. Applicants
  2. Positions
  3. Application-Positions: This third table is a master (parent) to Applicant records and also a master (parent) to position records. One Applicant-Position record can be related to one or many Applicants and to one or many Positions.
On the Applicant form, you would have an "Add Applicant-Position" button (maybe renamed "Apply for a Position"). Clicking this button brings up a form to create a new Applicant-Position record, with basic Applicant info (name, etc) copied from the Applicant record. On the form, the user would select a Position from a dropdown or browseable pop-up for Related Position. After saving it, they would then have to add another positon (technically another Applicant-Position record). So the user-experience will require some careful thought, but it is definitely doable.