Select from table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

There is no logical criteria to select employees for a project (from Table of
employees). The manager basically uses intuition and personal info.

Using a Form; manager would like to scan/scroll down employee list and
"pick" employees to be on project....i.e. be their records returned in the
query. Could be any quantity of employees up to several dozen.

Any one done something like this?

Kind of thinking along the lines of building an sql SELECT statement on the
fly AfterUpdate of listbox or something... but not sure how....
 
I assume you have a projects table. Create a ProjectEmployee table in a
one-to-many (1:m) relationship. Also create a 1:m from employee table to
the ProjectEmployee table.

Use a form with two subforms. Project with ProjectEmployee table as first
sub and employee records a second unlinked subform.

Use double-click event to append employee to the ProjectEmployee table. It
would append ProjectID form main form, EmpID from subform, and maybe Date()
as DateAssigned.
 
Back
Top