I have a project table linked to the employee table by employee ID. I have a drop down box that lists the current active employees. Their name is displayed in the drop box, but a number(employee ID) is stored in the table.
I start the project form with a defaut filter of active projects. If I want to add to this filter, I can right click on a drop down box like "status" and pick "awarded". This furthur filters the records to active and status-awarded.
However, if I want to filter on manager, right click on that field and add equal whoever the current manager is I get an error. How can I filter on manager, when the data stored in the table is actually a number?
TIA,
bdriscoll