Drop down object type problem

[rawia_tsalih]

I have problem with drop down type in browse form, I used SQL statement and it's work perfectly on edit form but on browser form show the id value not the name value ... please need urgent help

[admin]

rawia_tsalih,

If the dropdown displays a person's name for example it is getting it from the SQL used in the dropdown the field on the Form, actually stores the person's id,

You will see this if you look at the actual row in the database.

To display the name you must create a JOIN in the SQL of join both the table you are using and the table with the person's name.

And display the field holding the person's name not their Id, in the Browse.

http://www.w3schools.com/sql/sql_join_inner.asp

Steven

[rawia_tsalih]

dear this join statement I have to include it in dropdown object or in text object for browser and how do that

[rawia_tsalih]

Please I need ur help urgently

[admin]

rawia_tsalih,

Have you watched any tutorials?

https://www.youtube.com/watch?v=xLY3L1K_vqE&list=PLbyPJ4RnFyOpQy8XsNELQu8AJK7Eetc4R

Steven