How to display email address from table after autocomplete

Hi there

I am quite new to chronoforms and I have built a test form which does a autocomplete

I would like to know how to display the email adress below the selected full name (after autocomplete)
I have been through the forums but I am just getting more confused
here is a screencapture of the simple form
[attachment=0]screencap1.png[/attachment]
here is a screencapture of the events page
[attachment=0]screencap2.png[/attachment]
here is a screencapture of the sql file
[attachment=2]screencap3.png[/attachment]

Hi dawaster,

This is possible but there is no automatic way of doing it in CFv4; it has to be hand-coded. I'll try to take a look tomorrow (it's mid-evening here) and see if I can work out the best way to get it working.

Bob

Thanks for your prompt assistance in this matter

Hi there

have you managed to find a way to get this working

Cheers