Hi, I have a TABLE with a NAME column that contains duplicated entries for some records. I want to put the field values of this column into a combo box. The table is sorted on this column so that identical field values are grouped together.
But, since the combo box doesn't display the selected index properly if there are duplicate values, I need to rename the fields in the table column with something like name-1, name-2, name-3, etc.
I thought I was losing my mind until I noticed others on this forum had run into the issue discussed elsewhere whereby the table is dynamically re-sorting the records every time a field value is changed. I've had to come up with a complicated slice of code to deal with this, and I'm wondering if there's a simple way to handle this problem.
I'm thinking this really isn't an unusual thing one might want to do, so perhaps some of you have figured out the easy way? I'm guessing I probably missed something really simple, like I usually do, being a newbie to b4.
For instance, is there a way to make the table static while I update the fields, then turn on the sorting again? I don't see any command documented around this anywhere.
Tks, Adrian
But, since the combo box doesn't display the selected index properly if there are duplicate values, I need to rename the fields in the table column with something like name-1, name-2, name-3, etc.
I thought I was losing my mind until I noticed others on this forum had run into the issue discussed elsewhere whereby the table is dynamically re-sorting the records every time a field value is changed. I've had to come up with a complicated slice of code to deal with this, and I'm wondering if there's a simple way to handle this problem.
I'm thinking this really isn't an unusual thing one might want to do, so perhaps some of you have figured out the easy way? I'm guessing I probably missed something really simple, like I usually do, being a newbie to b4.
For instance, is there a way to make the table static while I update the fields, then turn on the sorting again? I don't see any command documented around this anywhere.
Tks, Adrian