AnsweredAssumed Answered

Combine Portal Fields to one field

Question asked by JessOttman on Oct 17, 2013
Latest reply on Oct 18, 2013 by philmodjunk

Title

Combine Portal Fields to one field

Post

     Hi All,

     Working with Filemaker pro 11 adv. On windows XP

     I have a portal in which I want two fields to combine in one description field out side the portal. Here's what i have:

     LineItems::Qty

     RelatedTable::Description

     What I would like to have in the Combined Field is "2 x Seal,1 x Procap.

     What I get is "2 x Seal" then when i click on the next portal row I get  "1 x Procap" and so on according on how many portal rows are occupied. 

     I have a combined field created as a text but input calulation :

I did manage to have "description, description, description" with this:

Substitute (List (RelatedTable::Description); "¶"; ", ")

So I then tried this:

Substitute (List (Line Items Test Report::Quantity); "¶"; ", " & "x" & Related Table::Descritption)

     I am at a loss so any help greatly appreciated if I could learn this for future reference

      

     Thanks

Outcomes