I am seeking advice or ideas on how to deal with dataset from asset that has multiple entries under the same field attribute. For example, in one particular bridge, it contains 3 parts in span material and structure. I am not sure what is the best way to display each of these information on Survey123 (prepopulate fields) given that they have the same fieldname. These data would be stored as related tables from the source database.
|FIELD_ATTRIBUTE||A1||A2 (start km)||A3 (end km)|
|STATUS_OF_BRIDGE||INSERVICE - MAINTAINED||169.61||169.742|
I could rename these fields by adding numbers to the end to make the repeats unique, but that would placed them at separate columns, instead of writing back to the same field attribute/column.
Any suggestions will be appreciated.