checkboxes in subforms

[bhakta.ram]

Hello All:

I have a incident table, action_taken table and incident_action_taken
table.

incident table
-------------------
iid(PK)
name
desc

action_taken table
-------------------------
aid(PK)
name
desc

incident_action_taken
-------------------------------
id(PK)
aid
iid

I have a main form and a sub form. Main form shows incident table and
subform shows incident_action_taken table. I want to show all the
"action_taken.name" field as a checkbox in the subform. I had a
"yes/no" column in incident_action_taken table but did not help.

I would appreciate if somebody can help me on this.

Thanks

[pietlinden]

If ou use a combobox its a no brainer. I think the wizard will do it
for you. Why would you want a checkbox? Especially if only one can be
true.