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

Bhakta,

Do you mean you want all possible Actions listed for each Incident? And
then a checkbox for each? If so, your idea of a Yes/No field in the
incident_action_taken table is a good one. But you will need to create
records in incident_action_taken table to match all action_taken
records. For this, you will probably want to run an Append Query into
incident_action_taken, every time there is a new record created in
incident table.

--
Steve Schapel, Microsoft Access MVP

(E-Mail Removed) wrote:
> 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
>