Single_Select with different option and value

Re: Single_Select with different option and value

maddogprod — Thu, 23 Feb 2012 01:42:01 +0100

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

Re: Single_Select with different option and value

DebbieS — Thu, 23 Feb 2012 01:24:13 +0100

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

Re: Single_Select with different option and value

maddogprod — Thu, 23 Feb 2012 00:31:36 +0100

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:

How do I set this up?

Thanks,
MD

Single_Select with different option and value

maddogprod — Thu, 23 Feb 2012 00:24:43 +0100

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