Printing problem in the field form

Applications Forms
#1

Printing problem in the field form

Salve in a field of the form I id mamera that in the database of the rooms corresponds to a name.
doing a select I;

SELECT nome_cam
FROM room
WHERE id = {room}
ORDER BY nome_cam

but in the field of the form I press; id name Room

how do I print only the name of the room with no id?

#2

hmmmm i didn’t understand what you mean

But i guess you are getting the id along with the field value

This is from field settings, go down under the lookup and find (Display original and lookup value) set to No

or if this is not the case, add a screenshot of your table and your field sql lookup