DaDaBIK
This forum is devoted to the discussion about the software DaDaBIK database front-end
the PHP Database application generator for MySQL, PostgreSQL and SQLite; also available for Wordpress.

Welcome! Log In Create A New Profile

Advanced

Single_Select with different option and value

Posted by maddogprod 
Single_Select with different option and value
February 23, 2012 12:24AM
Another quick question about dynamic Single_select usage.

- want to link (Primary Key Field) to an incremented field "RECORD".

- I want to display another field in the db (NAME) though it's fine to show RECORD also if need be (both would be LINKED FIELDS)

- If it's changed, I want it to update the field NAME, *not* Record.

How do I set this up?

Thanks,
MD
Re: Single_Select with different option and value
February 23, 2012 12:31AM
I tried to edit this but it wouldn't let me. I didn't explain it well. This is better:

- I want to link (Primary Key Field) to an incremented field "RECORD".

- I want to display another field in the db (NAME) though it's fine to show RECORD also if need be (both could be LINKED FIELDS)

- If it's changed, I want it to update the field NAME with the value of RECORD.

For a normal select it would be like: <option value="$RECORD">$NAME</option>

How do I set this up?

Thanks,
MD
Re: Single_Select with different option and value
February 23, 2012 01:24AM
Through the admin > interface configurator, select the field you want to set up as select_single and then set the options below:

Primary key table -- name of table you want to display options from
Primary key field -- RECORD
Linked fields -- NAME

_______________________________
..:: Debbie |\.-./| DaDaBIK Support ::..
Re: Single_Select with different option and value
February 23, 2012 01:42AM
Thanks. So simple. I don't know why single_select is so difficult for me. I guess because the nomenclature is so different from PHP, MySQL or anything else I use easily to do the same thing!

As I always say....one of these days I'm going to volunteer to rewrite the instructions to make a clear manual out of it!

THANKS
Sorry, only registered users may post in this forum.

Click here to login