We have a database where volunteers can signup and volunteer in our schools. The username and password are created by a script at the end of the registration. The login account is created when the background is approved.
We have this unique situation where we import the data over from the previous database. Because the username and password use different standards so we don't import them over. We have the script to create the username and password with the new standard. The issue we are having is that the username keeps overwrite the first entry. As illustrated in the screenshot, the 2nd volunteer's username is written into the 1st volunteer. We think our code needs to keep track of the initial volunteer and somehow reference back and assigns the corresponding username. Is there a function that will determine the current location of the selected entry within the entire data? If we can determine that and code that in, we think that is the answer to our issue.
Thank you in advance for any advice,
In situations like this, I normally implement a "legacy" field (or fields) and do a matching import between that field and the field in the old database that used the old standard. That way, you can do whatever you want for new standards and not overwrite data.