Question about Checkbox group

[RickBerem]

Hello,
I was wandering if it was possible for a checkbox group to return more than one object checked.

for example, My table relates to pieces of equipment used on different production lines... And some of these equipments are used on 2 lines or more. What I would like is that when the user is navigating through the equipments the checkbox group automaticly shows all the lines where this equipment is used and saves the modifications.

in my database the table LINES and the Table EQUIPMENT are linked with another table EQUIPMENT_BY_LINES

as shown here

LINES EQUIPMENT_BY_LINES EQUIPMENT
PK_NoLine ------> NoLine
NoEquipment <- PK_Equi

My checkbox group is linked with EQUIPMENT_BY_LINES

If this makes any sense to you your help would be appreciated...

Thanks

RickBerem

 

[scking]

Rick,

This is a little confusing. I think you need to provide a little more information. Would not a main form with a subform to implement the 1->>Many relationship provide the information in the correct format?

Are the checkboxes bound to what? NoLine and NoEquipment appear to be numerics which would not be appropriate for a checkbox.

Steve King