How to use a "lookup" to populate a field thats in the same record (Using a lookup to add more that one field to a record)

How to use a "lookup" to populate a field thats in the same record (Using a lookup to add more that one field to a record)

I am new to Zoho, however I have used another system similar to "Creator" this Caspio. I must say I love your system, very well designed and thought out. Bravo!!


I have one last issue I need to solve before my web application is finished.

Here is my problem: I have a form that uses a lookup to find another database table and use it for a drop down. What I want to do I pull two more values into this so that both are displayed when I submit. I am creating another form database so that I can find a record and add changes *without* having to resign the data that is already attached to the record. 

So in short I have a variable which is "XYZ" and I need other variables to be attached to it in my record when I press submit.

The information is already in its final format from my database it just needs to be linked with my new form.

Thanks

Jonathan
New happy Customer