MiddleValues ( ) add a return to the value.
Use GetValue ( ) instead.
I have a script that basically takes a students name and concats it with the current date and places it in a field called userHistory when a school instrument is assigned to a student. If another student is assigned the same instrument it adds the user name to the userHistory and separates them with a carriage return.
Why don't you create proper RECORDS (in a related table), with separate fields for the student's ID, the date, and the ID of the instrument assigned?
I am not following you. Student ID is a part of one table, and the instrument is part of another table. I am assigning the instrument to a student via the relationship between the tables. I just want to be able to track that instruments users over the course of many years...
I guess I just don't understand what you are saying, though I appreciate you taking your time to try and help....
I am saying that if you need to track the history of assignments of an instrument to students, then the relationship between Students and Instruments is many-to-many - and should be handled by a join table of Assignments, where each record is a single assignment of an instrument to a student.
See a demo here.
Thanks, now I understand what you are saying... Maybe that is the way to go.