Single_Select with different option and value

maddogprod

New member
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
 

maddogprod

New member
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
 

DebbieS

DaDaBIK Guru
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
 

maddogprod

New member
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
 
Top