Checkboxes on forms

V

Verky

Hi.

I have a form for updating business offers. These offers could refer to
any number of technologies (1 to n). I want that user could select
these technologies checking one or more checkboxes in the form with the
name of the technology.

How can I do that with Access in a easy way?

The offers table could be (only for example purposes): idOffer, name
The Technologies table could be: idOffer, idTecnology (These two fields
are primary keys)

I suppose I have to program some code in VB for get all the
idtechnologies for the Offer and mark manually the checkboxes. Is this
right?

Or are there any more automatizied way form making it?

Thanks in advance.
 
Top