Hello,
Yes you can create a formula to concatenate the fields together, remembering to reset the field on change of supplier. See below for details...
1. Create a Group on the Supplier # field.
2. Create a formula called Stock, and put it in the details section:
WhilePrintingRecords;
Global StringVar Stock;
Stock := Stock + {Stock # fieldname} + ", ";
3. Create a formula called ResetStock, and put this in the Supplier # Group Header:
WhilePrintingRecords;
Global StringVar Stock;
Stock := "";
4. Create a formula called PrintStock, and put this in the Supplier # Group Footer:
WhilePrintingRecords;
Global StringVar Stock;
5. Add the Supplier # field to the Group Footer and also suppress the Details section.
Note that the concatenated string will have a comma on the end,
(you can change this slightly to check if this is the first record in the detail section, if you're not sure how to do this let me know, it'll mean tweaking the ResetStock and Stock formulae).
Hope this helps,
Jo.
IP Logged
