Hello,

You'd more than likely want to do one of two things:

A) Either use calculated fields for name, surname, and email address - and place a lookup function on them to go out and grab the right values from the other list (you grab this function from the list of functions in the formula builder area).

B) Use cascading list lookups - this would allow you to start with one drop down and then when a value is selected, the other 3 dropdowns would be filled with the correct values.  This deviates slightly from what you described, because they would be selecting a value from a list of ID's instead of typing it in.

Thanks

Thank you appreciate you help

I think I will use B even thou its gonna be hard changing the clients mind on what they want

I though I could find a JavaScript to do that was avoiding to use drop down list

You're welcome,

Using a Textbox where you type in the ID, and then having 3 calculated fields based on what you type in sounds closest to what you want. This would be option A.  This simulates what you would do in JavaScript.