Drop down object type problem

Drop down object type problem

Postby rawia_tsalih » Thu Mar 17, 2016 5:24 am

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
rawia_tsalih
 
Posts: 6
Joined: Thu Mar 17, 2016 4:36 am

Re: Drop down object type problem

Postby admin » Thu Mar 17, 2016 11:29 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
admin
Site Admin
 
Posts: 3406
Joined: Mon Jun 15, 2009 9:53 am
nuBuilder Version: 4.5

Re: Drop down object type problem

Postby rawia_tsalih » Thu Mar 17, 2016 3:36 pm

dear this join statement I have to include it in dropdown object or in text object for browser and how do that
rawia_tsalih
 
Posts: 6
Joined: Thu Mar 17, 2016 4:36 am

Re: Drop down object type problem

Postby rawia_tsalih » Thu Mar 17, 2016 9:46 pm

Please I need ur help urgently
rawia_tsalih
 
Posts: 6
Joined: Thu Mar 17, 2016 4:36 am

Re: Drop down object type problem

Postby admin » Thu Mar 31, 2016 7:37 am

admin
Site Admin
 
Posts: 3406
Joined: Mon Jun 15, 2009 9:53 am
nuBuilder Version: 4.5


Return to Custom Code