Value List built from a database field

[SteveB]

I'm using FM5 & Win98. I have a field formatted with a value list built from a field in another database. This field always shows the 1st entry from the other database. Does anyone have a solution so that the current field is empty until the user clicks into it (so that it works like "hard-coded" value lists work)?

[Chuck]

The field shouldn't have any data in it unless it is set to auto-enter data or has a lookup associated with it. Double-check these items, and if one of them applies, then remove it. If it doesn't have either of these items, the field should be blank when a new record is created.

However, the way you are wording things, I think that perhaps it might be a related field (rather than a local field). Is this the case? Or is it a portal?

Chuck

[SteveB]

It is a related field and not from a portal. Shouldn't it work like every other field that's connected to a menu e.g. empty until you click into it?

[dspires]

I just posted this in another area, but it looks like it applies here too.

Make the default option value empty:

<SELECT NAME="Evaluator">

<OPTION VALUE="" SELECTED>

[FMP-ValueList: Evaluator]

<OPTION VALUE="[FMP-ValueListItem]">[FMP-ValueListItem]

[/FMP-ValueList:]

</SELECT>