On 31 Aug 2008, at 10:46, Beverly Voth wrote:
Steve, that was me asking what form.
Hi Beverly
Sorry I was too lazy to go back and find who wrote it... Your point
seems to be at the crux of the problem!
Barb,
I think your problem may not be design related.
If you are exporting a related field AND only get the first portal
row, then you are probably only selecting the field from the list
of fields as it is shown on the layout. However, if you first
select the RELATIONSHIP and the field as it is listed there, you
will find that all related portal rows will be exported.
As Steve pointed out and I said, the export from parent is very
different from the child. I'll give some examples:
PARENT:
Mr. Jones, class1, info
, class2, info
, class3, info
Ms. Smith, class2, info
, class4, info
...
Notice that only the first row gets the parent fields' data, if the
export is from the parent. Each suceeding row will have "place
holders" (see the commas?) From the child perspective, the same
relationship. Can look back at the parent fields. The export will
pull the parent fields into each child record.
Well, I'll be darned. I did not know that and had never tried it. In
fact, I recall (years back -- FMP5) spending quite a lot of effort to
get an export like this (with placeholders in subsequent rows).
Thanks for enlightening me!
I hope that helps Barb too!
Steve