Concatenate Fields

[sagsh]

Hi I need to create a form where users enter preferences
eg. reading / walking / cinema / computers / sports etc. In all their are some 75 options that a user can select of which they will select some.
Now I need to enter these values into either a text field or a memo field.

The field will not be used for enything else but a report along with user's name and address details etc.

I thought of using option fields but how would I then enter the values into a text/memo field in the database.

Any help greatly appreciated!

Sags

 

[Crilen007]

Well.. if you want it added as they click options...

it runs a quick little script that combines them together

So...

CheckBox A = "Gym"
CheckBox B = "Running"
CheckBox C = "Video Games"


use the form update event to update the text box?

strstring = "Gym"
strstring = strstring & ", running"

etc.. using if thens?

 

[WayneRyan]

sags,

You gotta store them in a table. One table for all preferences.
One table for all user/preference pairs.

Its not much extra work at this stage, then you can alphabetize
them, count them, etc. If they're concatenated together, you're
stuck with them like that.

Wayne