query is re-organizing data in a concatenated string

[gregu710]

That seems to have done the trick. SO, if I understand right, adding "Serial Number" into the ConcatRelated string maintains the order of the Serial Numbers? Interesting! Now I have to compare this to the setup I have for Controllers and figure out where I'm differing there, because it is still jumbling even with the new code. The two should be identical, but obviously not. Thank you for helping "set things in order"!

[pbaldy]

Happy to help! If you look at the function, it has an optional argument for sort order, which you weren't providing. It should work for the other too, though you may need to specify a different field.

[gregu710]

Happy to help! If you look at the function, it has an optional argument for sort order, which you weren't providing. It should work for the other too, though you may need to specify a different field.

Very interesting indeed. When I use "Unit" (the field that is supposed to control the order in all of the data tables) for Controller, it works as desired, i.e. everything is in the right order, whereas I had to use "SerialNumber" for the Motors table to get it to work right. Makes me think I have a "hidden" sort order somewhere that I need to ferret out! Of course, understanding the syntax and function of each part of a command definitetly helps a tremendous amount. Going to have to get into a class or do more studying, that's for sure!

Thanks for everything!