January 8, 200917 yr :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.
January 8, 200917 yr 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?
January 15, 200917 yr Author 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?
January 15, 200917 yr 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)
January 21, 200917 yr Author 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?
January 21, 200917 yr In the orig database. Its not an empty record as much as there is a space afer a carriage return.
March 10, 200916 yr 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
Create an account or sign in to comment