Combo-Box Filter/Autocomplete Question

[jhcarrell]

I have a form to track tasks by employees.

In this form the user must select the employee and position for each task.

Goal:
What I would like to do is make one of those fields autocomplete based on the other.

Issue:


Employees work in different positions from day-to-day. So having a set-in-stone parameter will not work in this case.

Solution?:
Would it be possible to have a form to assign and remove employees to positions at shift changes in order to meet the stated goal? How would I go about accomplishing this?

Note:
I had planned on using two drag and drop fields to filter "available" employees, but this will not accomplish my autocomplete goal.

Any help would be greatly appreciated.

Thanks.

[NTC]

To design a database, one must have a textbook - easily found at Amazon or any big bookstore.

In general, based on your post - those fields in their table may best be set up as LookUp fields allowing selection by the user from another static list table. These lookups involve a query which can use criteria from other fields so that they only offer an appropriate set of choices.

However there is other approaches depending on how you want the user experience to be - and it isn't clear as to what might be best.

Hope this helps a little.

[michaeljohnh]

If you want the second combo box to be a subset of the first, this is often referred to as "cascading comboboxes".

http://www.baldyweb.com/CascadingCombo.htm

[jhcarrell]

If you want the second combo box to be a subset of the first, this is often referred to as "cascading comboboxes".

http://www.baldyweb.com/CascadingCombo.htm

I see how this solution would work perfectly if employees worked in a set position. However, an employee may work 1 position on Monday and a different one on Tuesday.

As the parameters change from shift to shift, how would the cascading combo accomplish my goal?

[jhcarrell]

The attached example file may (or may not) help.

frmTask shows the two controls I'm trying to work with here.

I want to be able to manually assign employees to a position at shift change in order to autocomplete the employee field in frmTask.