B
Brett_A
I have a form where the first field is a dynamic drop-down that pulls
from a db (Access). The fields associated with the query are task_id,
task_name and task_rate. The field has the value of "task_id" and the
label of "task_name".
In the second form field, I would like the default value to be
determined by the selection made in the first field. Based on the
selection of the first form field, I would like the default value of
the this field (task_rate) to be populated with the associated
task_rate value of the selection chosen above.
Any suggestions?
Thanks
Brett
from a db (Access). The fields associated with the query are task_id,
task_name and task_rate. The field has the value of "task_id" and the
label of "task_name".
In the second form field, I would like the default value to be
determined by the selection made in the first field. Based on the
selection of the first form field, I would like the default value of
the this field (task_rate) to be populated with the associated
task_rate value of the selection chosen above.
Any suggestions?
Thanks
Brett