I am creating a view which should show the items ordered and the extended prices. The problem is the form shows multiple item and extended price fields. Since you can only choose one field for the column I am trying to figure out the best way to handle this. I have tried concatenated the items but they just list side by side on each line. I want them to show as separate values under the correct department. I have tried checking the field to separate values and using new line but it doesn't work. Also, I have used @if@isavailable to only show fields that are filled in but on the extended price it gives me a data type text expected error. would it be best to use an array here? There are so many items and prices that I am not sure how to handle it so that it looks right in the view. I am not sure how to create an array either. I am listed each field in a formula by concatenating them. I don't know if this is the best way. Any help would be appreciated. Thanks.
April 29, 2006 12:05 AM
April 30, 2006 6:01 PM