Earlier in this thread, someone asked what form you want your export
to appear in. I think this question remains pertinent and lack of an
answer maybe blocking the path to a solution...
So you have one record for Mr Jones and 10 course records for him.
How do you expect this to appear in Excel?
I assume that 10 Excel rows, each giving Mr Jones' demographic
information and one of his courses will not work for you. Obviously,
if it does, you simply export from the child file.
If you want one Mr Jones row in your export, giving demographic
information and then his courses in a, say, comma delimited form,
then you can use the List function to get all of the courses into a
single calculated field in the parent table. Export that along with
the demographic data, and you are done.
The third option is probably more tricky. Maybe this is the one you
want. A single Excel row for Mr Jones, including his first course.
Then rows with blank demographic data, each giving one of his other
courses. Is that your requirement? It should probably be considered
'poorly designed' data -- since sorting the rows would obliterate
their meaning -- but I can understand that such a requirement exists;
I've dealt with it at least once.
So what kind of format is it that you are looking for? If we knew,
I'm sure someone would come up with some kind of solution.
Steve
On 31 Aug 2008, at 05:47, barbpassman wrote:
When I export my FMP records to Excel.
Excel only picks up the first course listed in the uppermost row in
the portal.
I had hoped there was something I could do in FMP so that all the
values in the portal get exported but it seems that is not feasible
