Compile Portal Data into single field?

[skearton]

Hi Folks!

How does one right a script that would take data from a portal and compile it into a single list in one field for that one order?

I have a currently have a portal in my Order Table that shows what Purchase Orders are related to that job. I need to compile just the PO ID, the supplier name and the date ordered into a list that can print on the job docket.

Thanks again for all of the help!

[bcooney]

Create a calc in the child table, concatentating the fields that you need. So, dsp_line = POID & " " & SupplierName & " " & DateOrdered.

Then, in the parent table use List (relationship::dsp_line ).

[Fitch]

You could use a custom function, or define a calc field in the related PO table:

PO ID & " " & supplier name & " " & GetAsText(date)

Then in the parent table use the List function to grab the field... except the List function appeared in FileMaker 8.5. With version 8.0 you'll have to loop through the child records and compile the text into a field.

[bcooney]

Oh my, I really have to stop assuming everyone's using FM10.

[comment]

In version 8, you can use ValueListitems() - once you have defined a value list including only related values.

However, I don't see why it cannot be printed from the child table.

[skearton]

Thanks much all! That worked great. I'm on 10 now, but while we are convincing the powers that be to get everyone else on 10, I have to watch how I do things to be compatible.