I have a form that has multiple fields on it (some required some optional), and multiple locations.
I decided to build arrays to hold the data. The problem I ran into was that if a field did not have a value, it does not appear to create a slot in the array.
So, if on a form Location 1 had “item 1”, Location 2 was blank, and Location 3 had “item 10” in a field. When I build the array it has “item 1;item 10”. So now “item 10” appears for Location 2 instead of Location 3.
To get around the problem, when a field was blank I created a dummy value of “$”, so the array then gets built as “item 1,$;item 10”. I then change the $ to a space when I redisplay the field.
What am I doing wrong?
Gary