Dynamic Checkboxes

[Bari Samad]

I want to create dynamic checkboxes on a form for a
Creating/Viewing/Updating a Master table record. The values for the
checkboxes would come from a simple table (cause they may increase over
time) but be stored in a "transaction type table" for the master table (or
elsewhere?)

For example, one Organization (master table) could serve an x number of
languages.

The value of the languages should appear on a section of the form to create
an Organization (master table) record as checkboxes ... read from the simple
language table ... so if you added a new language it would appear next time
you created/viewed the form.

I am thinking the choices of the languages selected served should be stored
in a new transactional table - relational to the master - with the
organizationID field and the languageID field.

however ... once the master record is created and one needs to view/edit
it - the values must be read in both from the simple language (to show
possible new languages added) but also from the transactional table to
display what was selected originally.

Any thoughts/samples/ideas on how to impement this scenerio ... in terms of
database design and/or VBScript code?

Its really the checkboxes that are throwing me off !!!

Thanks

 

[Jeff Boyce]

Bari

Are you limiting yourself to only using checkboxes? If so, you are
overlooking other approaches... for example, use of paired listboxes (e.g.,
"potential languages" & "languages selected"). For an example of paired
listboxes in action, run the Access Query Wizard.

Good luck

Jeff Boyce
<Access MVP>

 

[Bari Samad]

Hi Jeff-

I am quite new to all this so thanks for the alternate suggestion. I will look into this.

One thing I am trying to kepp in mind is that the MS-Access form/database design I am developing is eventually headed to an ASP/VBScript based website (Dreamweaver - with which I have a little more experience). The Access form is just a interim way for my client enter the data. Your alternate may work with ASP/VBScript too. I am just trying to be mindful now - in the database design phase - so I don't have to pull my hair out then!

Thanks again

Bari