I can see 2 ways to hack something like that, but their might be a correct answer out there somewhere;
1. loop the add_record sub back to itself using some kind of a marking variable to know when to stop????
2. the only difference between a field and a record is a line break, so write the output with duplicated Customer ID's and line breaks between the products.
OK, here is #3
Since the products must come from a database somewhere, just store the ID of the product, then store all the product ID's in a single field, using multiple records for different orders.
1. loop the add_record sub back to itself using some kind of a marking variable to know when to stop????
2. the only difference between a field and a record is a line break, so write the output with duplicated Customer ID's and line breaks between the products.
OK, here is #3
Since the products must come from a database somewhere, just store the ID of the product, then store all the product ID's in a single field, using multiple records for different orders.