Tre questions about forms and Access Data project

[Mitmit]

Hi

Im using Access 2007 to develop a form where my users can insert, update and
delete from a MS sql 2005 database. I think its called Access data project.

1. I have a table with information that i would lika my users to select from.
This i simple to to a combibox where they can select it, but i would like my
users to see the options populated from the table to radiobuttons. Who can i
do that?

2. I have to tables, one with a category group, and one where i have
connected a group to have many options about the material of a group.
Say that i choose category1 from a combobox, and then want another combobox
to populate all materials from another table that is connected to this
category1. So my users dont se material that is related to category2.

How can i do that. I think i have the database ok, but dont now how to make
my form to do this.

3. Im also undering if i have to by a Access 2007 licens to all my users
that will run this application or if there is another way to run the
application. I guess i have to buy for all my users.