Problem:
I am trying to export from a FMP file to Excel so I can share the
data with people who do not own FMP or any relational database
manager.
Here is my issue- two issues
issue 1
The records each contain fields in portals.
When I export, choosing the fields to export, ONLY the data from the
portals exports, Not the data from the plain fields in the record,
even though I have selected those fields along with the portal fields
when setting up the export.
(I expected the inverse, that the data from portal fields do not
export, but they do , beautifully.
Issue 2
One of the portal fields contains several repetitions.
This is because the field pulls data from several records all
pertaining to one person.
The field lists credits for a given person, the credits being stored
in individual records for the same person.
I.e. Mr.Jones took five classes . The record of each class is separate.
The record I am trying to export is one which lists him and has a
portal pulling in all his credits.
The field "courses" has up to six repetitions so that that I can
show all of Mr. Jones's possible completed courses.
When I try to export ,only the first of the six values exports.
What do I have to do so that all fields export? OR isn't that yet possible?
My current solution was to show my records in LIST Format and print
into a .pdf format , which displays all the values in the portal
field.
But there must be a way to get all the values into Excel.
Thank you in advance.
Barbara Passman
Chicago
