Jump to content

Value List built from a database field


This topic is 8576 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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)?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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>

Link to comment
Share on other sites

This topic is 8576 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.