Saving information to a table field

[weircolin]

Hi

Really not sure if this is possible, however I will try to explain...

I am wanting to have a field on a form that will allow the user to see
information on the persons file of meetings they have attended.

I am upgrading the database for someone and at the moment they have a
checkbox for different events that have happened which is each held in
its own column. I would like it to be able to have a sub form or
something that would show each event that has happened and a checkbox
next to the events to say that they have attended.

Saving it into different fields is an option, but I would like to also
allow the user to easily add other events to the list without having
to go into the main table where the information is held.

If this doesn't make sense then I will attemp to reword.

Thanks

Colin

 

[Marshall Barton]

I am wanting to have a field on a form that will allow the user to see
information on the persons file of meetings they have attended.

I am upgrading the database for someone and at the moment they have a
checkbox for different events that have happened which is each held in
its own column. I would like it to be able to have a sub form or
something that would show each event that has happened and a checkbox
next to the events to say that they have attended.

Saving it into different fields is an option, but I would like to also
allow the user to easily add other events to the list without having
to go into the main table where the information is held.

The goal makes sense, but the table/fields fo not.
Following the rules of normalization, you need a separate
table for the meetings attended.

Since a person can attend many meetings and a meeting can
have many attendees, you need three tables:

tblPeople:
PersonID (Primary key)
PersonName
. . .

tblEvents:
EventID (Prinary key}
EventDescription
EventDate
. . .

tblAttendees:
PersonID (Foreign key)
EventID (Foreign key)
Grade
. . .

Then you can use a continuous subform to list the events and
attendees.

 

[weircolin]

Thanks for that.

Will I be able to show this information on a form?

Colin

 

[Marshall Barton]

Will I be able to show this information on a form?

Certainly. The common approach is to use a main form bound
to the table of interest, either the people or the event.

Then use a subform (probably in continuous view) bound to
the attendees table. The subform would use a combo box with
its RowSource set to the table that is not used in the main
form.

 

[weircolin]

Hi

Thanks for that info. I have created the tables but not sure how I
will be able to show it on the main form I use i.e. the one that holds
the information of name, address etc for each of them.

Colin

 

[Marshall Barton]

Thanks for that info. I have created the tables but not sure how I
will be able to show it on the main form I use i.e. the one that holds
the information of name, address etc for each of them.

Create the main form and set it's RecordSource to the people
table. Then add text box controls for the fields by
dragging a field from the Field List window (View menu) and
dropping it on the form.