Hi There

I need to get employee usernames from employee table multiple times in one single form.

E.g. : Emp name: input with auto complete

Manager Name: input with auto complete

Project Manager name: input with auto complete

DU Lead Name: input with auto complete

HR Manager Name: input with auto complete

etc..

Is there any chance i can use one aggregate for all widgets instead of every time each input text box changes?

Note: No relation or related columns in a row( above table is just an example  to give you clear understanding).


Thanks in advance.


Assuming you are doing some similar type of data, you should have your lists bound to return just people with the same role. ie.. do an aggregate that just brings back project mgrs. Do the autocomplete for proj mgrs against that.  Another one for leads,etc.  I woud be hard pressed to come up with a situation where the same people could be any of the roles. In this manner, you have the appropriate people in the right list.


Thanks


Stacey

Thank you Stacey.

But the problem is. we don't get roles from the aggregate and there is no option too.