auto updating tables

  • Thread starter Thread starter m
  • Start date Start date
M

m

I have a scheduling database. One form allows an
administrator to add new classes, which populates a class
table ("tblclass"). A second form allows employess to
enroll into a class, which populates a enrollment table
("tblenrollment"). I need to have a third form which
allows the administrator to approve/disapprove the
employee enrollment. However, I am having difficulty in
going about this procedure because I need to have the
tblenrollment and tblclass joined into a third table each
time an employee enrolls into a class. This way I can
have the third form pull only the employees that have
enrolled in a class, but have not been approved yet.

Any suggestions would be appreciated. Thanks.
 
I probably should go into more detail of my situation....
I need to have a third form allow the administrator to
approve/disapprove the employee enrollment. I have used a
subform on the form that allows employees to enroll into a
class... and at first was thinking that I could go about
this the same way. However, I have my third form, which
allows the administrator to approve/disapprove the
enrollment, not being able to pull up the employees who
have enrolled in an available class and need to be
approved.
 
I have a scheduling database. One form allows an
administrator to add new classes, which populates a class
table ("tblclass"). A second form allows employess to
enroll into a class, which populates a enrollment table
("tblenrollment"). I need to have a third form which
allows the administrator to approve/disapprove the
employee enrollment. However, I am having difficulty in
going about this procedure because I need to have the
tblenrollment and tblclass joined into a third table each
time an employee enrolls into a class. This way I can
have the third form pull only the employees that have
enrolled in a class, but have not been approved yet.
Click to expand...

You certainly do NOT need a redundant third table! Your Form can, and
should, be based on tblEnrollment. You can display the employee's name
and the class name using Combo Boxes. The simplest procedure might be
to simply have an "Approved" yes/no field in the table; this would not
be editable (or perhaps not even included) on the employee's form, but
would on the administrator's form.
 
Back
Top