The Mad Jammer Posted April 30, 2003 Posted April 30, 2003 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 Posted May 1, 2003 Posted May 1, 2003 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 Posted May 16, 2003 Author Posted May 16, 2003 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 Posted May 17, 2003 Posted May 17, 2003 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 Posted May 19, 2003 Author Posted May 19, 2003 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 Posted May 19, 2003 Posted May 19, 2003 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").
Recommended Posts
This topic is 7846 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 accountSign in
Already have an account? Sign in here.
Sign In Now