Dynamic value list should have 5 values but keeps growing after each record?
Hello, I am using FMP12 and I have a very simple script which you can see in the screenshot below. It does the following:
1. Clears the value_list_pdu_1A1A field.
2. Sets the variable $VALUE to the contents of field PDU 1A1A from the previous record.
3. Sets the value_list_pdu_1A1A field to $VALUE-2 $VALUE-1 $VALUE-1 $VALUE+1 $VALUE+2 with carriage return between each one.
I set field PDU 1A1A to use a value list which gets the values from the value_list_pdu_1A1A field. The value_list_pdu_1A1A field is populated fine but instead of PDU 1A1A showing only 5 values to choose from. It just keeps adding to the value list. So if I start with 50. The value list in the next record will be 48, 49, 50, 51, 52 as it should be. Then if I select select 52 in this record the next record's value list contains 48, 49, 50, 51, 52, 53, 54. The value list never clears. It just keeps adding more values to the list forever... what am I doing wrong? Thanks for any help.