Dropdown field data duplicates despite field names being different

[nickw7coc]

I created a form and populated it with a row of 27 fields, some of which are a dropdowns.  Then I selected all fields and copied to another row, 10 rows in all. 

The software is clever enough to add # then a number in sequence plus one every new row.  So now I have "Installation Week#1" and "Installation Week#2" etc. for example.

But, when I populate the form using the drop-down list, every field displays exactly the same data as "Installation Week#1" and if I delete any of the entries is deletes all of them.

Each column has a unique name, it's just that each row has # followed by the number of the row, that has been automatically added by the software, and to edit each of the fields is going to take me too long and too much effort.

PLEASE tell me it's something that's simple to resolve...

TIA

Nick

[try67 · Accepted solution]

The software is clever enough to add # then a number in sequence plus one every new row.

Actually, it's not that smart... Those notations only mean that they are different "widgets" with the same field name, and therefore will have the same value.

If you want to duplicate a field so that each copy is unique you can use the Create Multiple Copies command when you right-click it in Form Edit mode. Alternatively, it can be done using a script.

[nickw7coc]

Ohhhhh so that's how you do it

Super answer, well presented, TVM