Need fields to auto populate data from a choice in a dropdown field

Hi there, I'm hoping someone can help me please, I've been scouring the forums and Internet and can't seem to find an answer to my particular problem.

Like the original poster above I am looking to autopopulate 4 fields after a dropdown box selection. In my case it is the 2nd dropdown box of 2, where the 1st dropdown box determines the choices in the 2nd.

Using the 2 articles above,

https://www.pdfscripting.com/public/List-Field-Usage-and-Handling.cfm

https://acrobatusers.com/tutorials/change_another_field/

I have managed, through a lot of trial and error, to figure out how to get this working.

My issue/problem lies with me wanting to have multiple rows of the same 2 dropdown boxes and 4 autopopulated field boxes. Whenever I try to set that up the best I can come up with is that both dropdown boxes work correctly but the text fields all give the same data (the data for the first row), on each of the subsequent rows even if the dropdown choices are different. I can't seem to figure how to get them working independantly.

For clarification: Dropbox 1 is a choice of magic school, Dropbox 2 is a choice of spell from the previously chosen school in Dropbox 1. The 4 field boxes represent the 'Casting Time', 'Duration', 'Type' and 'Ingredient' of the spell chosen in Dropbox 2.

I can get one line of this working correctly, where all 4 text boxes correctly display the information of the chosen spell but cannot figure out how to get each subsequent spell chosen in the next row to display the information independantly.

Any help at all would be gratefully received as I'm trying to set up a form fillable character sheet for a typing impaired person.

Jim