value list "empty" value

[dannau]

Hello to all,

I'm finishing a small internal FM9 database of hotels, services and prices (I have a tour operator business that organizes tours to Chile and Argentina). At one point, our operators ahve to use several drop down lists with the services that hotels offer (pool, internet,massage, etc). But if they make a mistake and want to leave the field empty, they just can't. How can I do this? Can I somehow create an "empty" value that would appear in the drop down list?

Thanks for the help,

Mark

[The Shadow]

Well, you could have the string "" shown in your valuelist, then add an auto-enter calculation (always replace value) that looks like:

  If (yourField = ""; ""; yourField )

[dannau]

thanks shadow,

I tried it but it doesn't seem to work, I now have a value in the record. Note: I have activated the edit value in the drop down list, maybe that is the reason.

mark

[The Shadow]

That makes it sound like you didn't setup the auto-enter properly. You need to unselect the "do not replace existing value" checkbox.

See the attached example file, it seems to work fine for me.

Fruits.fp7.zip

[dannau]

Thanks for the help shadow. With your help I've managed to do just what I needed.

Cheers,

Mark[color:green]