assign a recordset to a variable
Bit of a newbee question
I need to add 3 repeating fields from a orders table into one variable. I can display the records but not sure how to store them in a variable.
For example my variable is "items"
recordset fldName fldNum fldQty
variable "items" should = tshirt 123abc 5, shorts 123xyz 2
and so on