I got the results I needed with the Advanced Search but when I added an additional Column it did not show up.
When I moved that field up in the Customize Display, it was there but
the last field on the list did not show up.
It looks like only 7 columns can be displayed, no more. Even tho there is a lot of white space to the right of column 7 where the additional columns should be.
Customize the People View shows up to 11 columns just fine.
At first I saw the limit you spoke of. Then while I was checking customize on the People List View and the Basic Search all of a sudden I could add more columns on the Advanced Search and it would display them all. Not sure which one triggered it to start working. I can’t report this unless I can recreate why they weren’t showing in the first place.
@rzamor1 and @MadDog --Sorry MadDog–it’s NOT Halloween gremlins as I’m having the same issue in every database I open-- BTW, you can have more than 11 columns—I’ve tried 36–so I guess you could have all of them if you wish…
3rd database I have tried and all have been the same— this time I went into People List first and added 1 more column
then went into Search and increased my customize column list to 25 ( started off with 5)-- clicked okay and only 1 was added…
NOTE that the People and Search Columns NOW show the exact same columns and the exact same amount of columns..
Played with this quite a lot and what I found so far is that however many columns you have showing on the Advanced Search page depends on how many columns you have showing on the People Search page…meaning if I have 6 on the People Page, it will only show the first 6 (out of 15) I have chosen on the Advanced search page ( and they don’t have to be the same 6 columns). @rzamor1 -If I go back to my People List and reduce the customized columns back to the original 6, my 15 columns in Advanced ( and Basic) Search will still show UNTIL I close and back up the program— the next time I go back into the program Advanced search will only show 6 even though I have 15 in the Customized List window…
and typically a runtime 217 error after closing…
The interesting thing was after the access violation showed up and I closed and reopened same database in RM 11 where I had 25 columns selected for Advanced Search and 6 for People List, there would be 7 columns that showed in Advanced Search..
I’m not sure what the limit is on columns but I would not recommend adding more than is reasonable. If you added 36 you may have hit the limit. See if restoring a backup made before adding them all will fix it.
Your “List index out of bounds” and getting 7 columns instead of 6 and other cases of things being off by 1 is suggestive of programmer confusion because in some cases numbering begins at 1 while in others it’s at 0. An array might have 6 rows with the first at 0 and the last at 5 while the corresponding record numbers in a database table are from 1 to 6. Likewise for columns. Any mapping between the two has to take that into account and is easily overlooked.