Create a question list for Recrutiment

It looks like your application may need a more complex structure. Instead of having the Questions on the same table as the Application, I would encourage you to think about setting up a separate table that would end up being your pool of Questions. Since some of your questions may NOT change from one position to another, you would need only a single record for each unique Question. I would then have a Positions and a Position-Questions table. Positions would be just the list of different positions you have need to generate Applications for. Position-Questions would be where you associate the different Questions with each Position. Finally, you would have an Applicant-Questions table where you would associate the Application and the Position-Questions. The Answer field would be on the Application-Questions table and you would probably want to place them in an editable embedded report on the Application form. The structure for this setup would look something like this:



------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------