I am trying to write a database to record which employees are pre

[Guest]

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.

 

[Vanguard]

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.

Is this really an Outlook issue? Sounds like you want to figure out how to
code macros in Access (or maybe Excel). If you are trying to figure out how
to program a VB macro for Outlook, try talking to the folks over at
outlookcode.com. Or go ask in a newsgroup appropriate for whatever
"database" you are using.