Top Record Empty

[solver resolve]

:P I am not sure why this happens. I am pulling a related list from a third party location. The list has no blank records. However the top record in my list is always a blank? Anyone ever have to deal with this?

The record cannot be blank as the field needs to be mandatory. However, it does not read as a blank field?

perplexed.

[bruceR]

I am not sure why this happens. I am pulling a related list from a third party location. The list has no blank records. However the top record in my list is always a blank? Anyone ever have to deal with this?

The record cannot be blank as the field needs to be mandatory. However, it does not read as a blank field?

perplexed.

We are likewise perplexed until you provide meaningful detail. What does "pulling a related list" mean exactly? Your profile says you are using FM7, which has no list function. What exactly are you doing?

[solver resolve]

I use a drop down list to use values from another fm file.

The other file has no blank records. However when in browse mode and choosing he field, the top choice in the value list is a blank?

This allows the user to choose this blank space. So, the field can remain blank.

The CFO wants info to never be blank in this field. I tried validation but somehow the field seems to have data in it even when it is blank, from this mystery chosen blank data, in the drop-down list?

[mr_vodka]

If the value list is based off a text field, you shoudl double check all your records to see if there is a record with a space in it.

Especially if it is hidden where its not erally visible such as the following:

field name: color

blue

_

( underscore representing a space on a second line)

[solver resolve]

I do a search for empty records, should I try to trim text? If so, would you do this on the original database or the destination field that the value list populates?

[mr_vodka]

In the orig database. Its not an empty record as much as there is a space afer a carriage return.

[Skipi]

Check out this

http://www.fmforums.com/forum/showtopic.php?tid/194581/pid/287287/

It worked for me. I turned off the allow creation... and my blank record was gone.

:B