display all participants in a subform at once & select from them

[Dean Welch]

I am trying to write a database to record which employees are present during
meetings. I have an "employee" table and an "event" table and an
"attendance" cross table between them that has a combination of foreign keys
from each of the parent tables. I want to show the event table in a main
form and the attendance table in a subform. I want to be able to click a
boolean field called "present" beside each employee to indicate those
employees present. The problem is that I want to show all employees in the
subform at once without having to select them individually, indicate whether
they are present or not in the "present" boolean, then have the event number
from the main form pass to the subform and post those records to the
"attendance" cross table. I have tried many things without total success.

 

[John Welch]

Hi Dean. Not sure if you know this, but it's not a good idea to post the
same message separately to more than one newsgroup. ( I noticed that this
one is also in mpa.tabledesign) The reason is someone may spend a lot of
time giving you a detailed answer in one newsgroup only to notice later that
your question was already answered in another newsgroup. If you post the
same message to multiple groups at the same time ( like sending one email to
multiple recipients), however, it works better because any response you get
in one group shows up in all of them.

Sorry, I don't have a solution to your problem at the moment.
-John

 

[John Vinson]

On Sat, 24 Dec 2005 08:45:01 -0800, "Dean Welch" <Dean

I am trying to write a database to record which employees are present during
meetings. I have an "employee" table and an "event" table and an
"attendance" cross table between them that has a combination of foreign keys
from each of the parent tables. I want to show the event table in a main
form and the attendance table in a subform. I want to be able to click a
boolean field called "present" beside each employee to indicate those
employees present. The problem is that I want to show all employees in the
subform at once without having to select them individually, indicate whether
they are present or not in the "present" boolean, then have the event number
from the main form pass to the subform and post those records to the
"attendance" cross table. I have tried many things without total success.

Answered in your (oddly titled "Access") thread in
m.p.a.tablesdbdesign.

Please, if you wish to post a question to multiple newsgroups,
crosspost to all of them rather than posting the same message
separately to each. This helps volunteers identify already answered
posts.

John W. Vinson[MVP]