Welcome to the nuBuilder forums!
Please register and login to view forums and other content only available to registered users.
Please register and login to view forums and other content only available to registered users.
Drop down object type problem
-
- Posts: 6
- Joined: Wed Mar 16, 2016 8:06 pm
Drop down object type problem
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
-
- Site Admin
- Posts: 2781
- Joined: Mon Jun 15, 2009 2:23 am
- nuBuilder Version: 4.5
- Been thanked: 1 time
Re: Drop down object type problem
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
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
-
- Posts: 6
- Joined: Wed Mar 16, 2016 8:06 pm
Re: Drop down object type problem
dear this join statement I have to include it in dropdown object or in text object for browser and how do that
-
- Posts: 6
- Joined: Wed Mar 16, 2016 8:06 pm
-
- Site Admin
- Posts: 2781
- Joined: Mon Jun 15, 2009 2:23 am
- nuBuilder Version: 4.5
- Been thanked: 1 time
Re: Drop down object type problem
rawia_tsalih,
Have you watched any tutorials?
https://www.youtube.com/watch?v=xLY3L1K ... AJK7Eetc4R
Steven
Have you watched any tutorials?
https://www.youtube.com/watch?v=xLY3L1K ... AJK7Eetc4R
Steven