Check boxes

[Guest]

I have a tabke with items A thru Z
I have another table with Categories like Fruit, Nut,
Veggie.

I would like to create a form to list all the items (A to
Z) with check boxes for Fruit, Nut and Veggie. Depending
on what is selected, populate the Items table with the
correspoding entry. Example:

Form
Fruit Nut Veggie
A check box check box check box

If the user checks Fruit for A, table A has field category
populated with F.

How do I go about it?

Thanks