Is there way to keep same questions/fields in the one table? 1

[gdev]

Please help,

Each construction project has an unique set of initial and monitoring questions to be answered.

The construction project can have many locations and may have multiple monitoring questions in 6 months intervals.
Also, some of initial and monitoring questions are the same. Some of the questions are the same for all the projects.

I would like to keep the initial and monitoring questions in the same table, but I don't have a way to identify the questions/fields that are the same for both. I have an inital and monitoring table for each project.
Is there way to keep same questions/fields in the one table?

tproj fields: proj_id, location, dteEntered, name
tprojA_questons fields: q1,q2, q3, q4, etc
tprojAns fields: proj_id sublocation, q1,q2, q3, q4, questionType

Thanks

 

[dhookom]

You might want to take a look at for At Your Survey and the Employee Evaluation.

Duane
Hook'D on Access
MS Access MVP