Is it possible to autofill a field based on what is entered into another
field in a form? My form has an employee field, and department field.
In an Items Table, I have fields FldEmployee, and FldDepartment.
FldEmployee is looked up from an TblEmployee Table which also has fields
FldEmployee and FldDepartment. This FldDepartment field is looked up
from a TblDepartment table that just has FldDepartments. I hope I
explained that OK
The form is based on the Items table. I'd like the Department field in
the Items table to autofill based on which Employee is selected, and be
able to select a department even if no employee has been selected.
Is this possible? easy, hard? Can someone help me or point me in the
direction where I can read how to do this?
Thanks everyone, this newsgroup is a lifesaver!
Ray
field in a form? My form has an employee field, and department field.
In an Items Table, I have fields FldEmployee, and FldDepartment.
FldEmployee is looked up from an TblEmployee Table which also has fields
FldEmployee and FldDepartment. This FldDepartment field is looked up
from a TblDepartment table that just has FldDepartments. I hope I
explained that OK
The form is based on the Items table. I'd like the Department field in
the Items table to autofill based on which Employee is selected, and be
able to select a department even if no employee has been selected.
Is this possible? easy, hard? Can someone help me or point me in the
direction where I can read how to do this?
Thanks everyone, this newsgroup is a lifesaver!
Ray