tough "summary" field

[yafreax]

I have a solution in which clients can order up to 50 different items. I have a calculation field that corresponds to each order field that will show the description of what they ordered. For example, they put an X or a quantity (2, 5, etc. ) in a field called "Item1." In order for us to have easy reference without looking to our reference sheet, i have a field "descItem1" that is a calculation:

if(IsEmpty(Item1),"","Item one description").

I have a description field for each item field. Now we must have a Job Ticket print all information for each order. in this field i basically need the calculations to be like a merge fields. I had the following calc:

descItem1 & " " & descItem2 & " " & descItem3. . . .

Problem with that is it gets messy and hard to seperate one item from the next. Lets assume someone orders item 1 and 2 and 5; I would like the field to list like this:

descItem1

descItem2

descItem5

it's a calculation field so i have to enter the "

[yafreax]

Well, that worked. . . i was originally getting nothing in the field. Maybe i just kept missing something. I ended up making a copy of the field and starting the calculation completely over. . .

oh well, i'll put you on my hero list even if i pretty much had it right .

Here's another question, new topic. . .

All of a sudden, none of my plugins (including WC, TCP/IP, etc) won't load. . . any suggestions. . . i really don't want to have to reload Filemaker. I'm using 5.0 on a Mac OS 9.0.4

------------------

Filemaker's kind of like a wife; easy to love, yet just so complicated.

[LiveOak]

Your calculation look like it should work. I would change it slightly:

if(IsEmpty(item1),"", descItem1 & "