Update Text field based on Drop Down box

[robtarr]

I have a drop down box where the user selects a name from the "Team" table. I have another field called "Grade" and would like it to display the grade of however was selected. How can I do this?

Thanks

 

[79ssecca]

I have a drop down box where the user selects a name from the "Team" table. I have another field called "Grade" and would like it to display the grade of however was selected. How can I do this?

Thanks

In the drop down adjust the lookup sql to include both the name and the grade. You don't have to disply it here but just add teh field to the lookup. Then in the Grade control set the source "=dropdown.column(1)" where drop down = the dropdown controls name and the column is the column counted position in the sql statement starting from 0 as the first column.

Good luck
79ssecca

 

[robtarr]

Thanks

Works great, thank you very much!!