This topic is locked

custom insert field type

4/1/2009 11:11:51 AM
ASPRunnerPro General questions
S
silk author

hello,

I ask but I think there's no solution..
I have 2 values to insert in 2 fileds of the DB (height and width of an item), but I want them to be inserted as a single choice with default values OR custom values, eg:
-option 1 (200x300)

-option 2 (400x600)

-custom (please specify: x )
is this possible?
thank you

R
Roger 4/1/2009

There a two quick possible solutions:

  1. Use the Lookup Wizard to Create a new Drop down list and enter your standard values there,
  2. Create a table in your DB with the standard values.
    Then in the Lookup Wizard (regardless of which one above you chose), click the Check Box "Allow to add new values on the fly".
    Hope it helps.

jtksmith 4/7/2009

Roger / Silk,
Excuse me for barging in but this topic really interests me. I tried to do as Roger described by creating a list of values and then creating a table in the database holding the same list of values. When I select the "Lookup table" as the option, pointing to the new table, and "Allow to add new values on the fly", it works but the new values then get recorded in the database table and appear the next time the dropdown is used. I don't want the new "custom" values to remain for the next time; I only want the "default list" to be offered. If I select "List of values" as the option, the "Add" link doesn't appear next to the dropdown list anymore. Am I misunderstanding or not following your suggesstion correctly?