Drop down object type problem

rawia_tsalih · Unread post by **rawia_tsalih** » Wed Mar 16, 2016 8:54 pm

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

Unread post by **admin** » Thu Mar 17, 2016 2:59 am

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 · Unread post by **rawia_tsalih** » Thu Mar 17, 2016 7:06 am

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

rawia_tsalih · Unread post by **rawia_tsalih** » Thu Mar 17, 2016 1:16 pm

Please I need ur help urgently

Unread post by **admin** » Thu Mar 31, 2016 12:07 am

rawia_tsalih,

Have you watched any tutorials?

https://www.youtube.com/watch?v=xLY3L1K ... AJK7Eetc4R

Steven

nuBuilder Forum

Drop down object type problem

Drop down object type problem

Re: Drop down object type problem

Re: Drop down object type problem

Re: Drop down object type problem

Re: Drop down object type problem