Value List snafu

[The Mad Jammer]

I defined a value list (valListA) in FileA with the Use values from field: option. The field I chose to populate the list is in a different file (FileB). I also defined a field in FileA that is formatted as a pop-up list and uses valListA to display values. The odd thing is that I am getting some extraneous blank entries in the pop-up list. There are no blank records or fields in FileB.

So then, I put a portal on the FileA layout and inserted the same field as valListA into the portal. There are no blank entries in the portal. Needless to say I'm a bit mystified. Why are there extaneous blank entries in the pop-up list?

Thanks

The Mad Jammer

And then...there was nothing

[cmartin]

Perhaps you have carriage returns in some of the entries in the field? That may cause what appears to be a blank field but is actually the second blank line of the value above it. Not sure about that, though.

Have you tried defining the value list in FileB. And then in FileA choose the option use Value Lidt from Another File. Would be curious to know if the same problem occurs?

-Courtney

[The Mad Jammer]

A field in File B is actually being used to populate the value list. File B consists of two fields, one field with a constant in it and a date field. The date field is providing the values for the value list in valListA.

At first I thought carriage returns or white space was the culprit too but I've deleted every character after the actual value in the date field of File B.

So I'm still stumped. The open spaces in the drop down list only happen after a couple of the dates and I have made an extra effort to be sure that the records that contain those values have no extraneous characters.

The Mad Jammer

And then...There was nothing

[Peter Fenner]

I've had a similar problem some time back, I think it had something to do with the indexing settings of the applicable fields. I can't really remember, but maybe you want to have a look at your indexing settings.

Pete

[The Mad Jammer]

Thanks Pete, I'll look into that. I know that the file (File : is indexed by date so that the dates show up in chronological order in the pop-up list, but the records in File are not necessarily in chronological order. In other words 01/01/2003 shows up before 12/01/2002 in the records list.

The Mad Jammer

And then...There was nothing

[Ugo DI LUCA]

Hi,

1) So you said you placed the fields in the portal and that no empty record was in there. Are you sure this extra empty record didn't jumped at the end of the portal list, according to your sort key.

2) I'd made an extra calculation to see if there is a problem in the list.

c_checklist = Substitute(ValueListItems(Status(CurrentFile, "your value list"), "pp", "space") - Unsorted (where pp is a carriage return)

I really mean "space" as litteral text.

Look at the field and check if no occurrence of "spacespace" appears in there with c_checkCarriages = Patterncount(c_checklist, "spacespace").