Concatonating related text fields

[Dave Martin]

Okay, I've searched through FMP8 help, searched online, searched here to no avail.

I'm trying to build the HTML code for creating product "sets" on Cafepress. I have one DB to define the set, and another for the products which would comprise the sets.

Right now, the sets I have each contain twelve products, but I'd like the flexibility to use other varieties.

I could pull the calculated codes from each of the twelve products related to the set manually, but I'd rather concatonate the found related items into a calc field in the Sets DB.

Maybe there is no way to do this, or maybe I'm just overlooking the obvious solution. Or maybe I'm not doing a good job describing what I'm trying to do.

I'd appreciate any insight, suggestions or even puzzled queries. I've been developing with FMP since the early 1990's, but have never had a need like this before.

Thanks to all in advance!

[Genx]

Concactonate how?

Product1 & " " & Product2 etc?

[Genx]

Anyway, take a good look at this topic, i posted a custom function here as an alternative to the 8.5 list() function.

http://fmforums.com/forum/showtopic.php?tid/184368/post/239487/hl//