Storing all portal items in 1 field

[npw5]

Hi there,

I (re)built the FM example of the webstore which comes with the Filemaker 5 package.

[Eggshen]

In your database, make a value list that gets its values from your relationship's related field (This should be all the values in the portal). Then your calculation can be ValueListItems(Status(CurrentFile), "NameOfValueList"). I think that should do it. There may be some other way to do this as well, but I sure cant think of it at the moment.

[Ender]

You may have some formatting issues with the value list technique. You may need to build additional calculation fields to format the OrderItems lines (concatonating Description, Qty, Price, etc, and adding spacing.)

Another idea for this is a scripted approach. Build the portal data with a loop, appending the text to a results field.

[Vaughan]

The value list method strips all formatting, sorts the items in alphabetical order, and removes duplicate entries. It is usually the last one that is the killer.