Subform, multiple selections...

[EgWeb]

I have a question relating to subform's...

I have table that I refer to as the "register" and then some sub tables, one of which is "estimators".

Here is a real scenario. We have a project that we are tracking, we have multiple estimators for that project. How do I asign multiple estimators from the estimators table, to the project? The "Estimator" field in the register is linked to the "ID" field in the estimators table.

Thanks,
Andy

 

[nrugado]

Create a table that has the following fields.

EstimatorID and ProjectID you would have a dual PK that would allow multiple Estimators to a project.

 

[EgWeb]

Sorry, I don't quite understand how that works...

Is there a way I can have check boxes, check the estimators, and the people checked relate back to the register?

Thanks again!
Andy