save multiple events in one field

[mxp346]

I have a paper form where there is a list of events that can occur during a visit. The person can check off several of the events. Is there a way to make a form so that if there are several items checked they will all be stored into the same field? Or would I be better off doing it some other way were they would be stored in different fields or something else?

 

[Darrylles]

Hi MXP136,

Please elaborate on what you actually want.

Your phrases such as 'paper form' don't make sense.

Tell me in your words exactly what you want - e.g. I want to see user choices from the following options ... blah.. blah...blah displayed on a screen or printed to paper etc.

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[WildHare]

MX, what you probably want is a child table to your main record with your event(s) stored:

Main : VisitDate
VisitPerson
etc etc etc

Child : VisitDate (Foreign key to Main
Event "Knocked on Door"
Checked YES

VisitDate Same Key
Event: "Said Hello"
Checked YES

and so on. Thus, you can either pre-populate your child table with all the events possible for a "visit", and set them to YES where they are checked off (or rather, ON) on the paper form, or just post the YES/TRUE events in the child record.

It's just a matter of design, and your particular business rules will dictate how you set it up. Get back if you have more questions.

Jim
How many of you believe in telekinesis? Raise my hand...
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm