Barbara , 1) The "canned" export as Excel may not work if Excel does not understand "related fields" and "repeating fields". What do you want the data to actually look like on the other side? It would have to be "flattened", right? :)
2) are you trying to export from Mr. Jones' record or are you trying to export from the related classes? What you export may be very different depending on your perspective. 3) yes, repeats in related portals do not export except the first one. See help topic: "Contents > Saving, importing, and exporting data > Exporting data from FileMaker Pro > Exporting repeating field data" Could these "repeating" fields actually be one field using a calculation, for example to gather all the repeats? That would export just fine as one field (even related). -- Beverly Voth Tier3 Data & Web Services Group, LLC 606-864-0041 http://www.tier3web.com/xml.htm Web Design & Hosting * Apple: CAN, ACN & ADC Certified FileMaker 7 & 9 Developer * FileMaker Business Alliance Coldfusion, Witango, PHP, MS SQL, MySQL, FMP, XML/XSLT, CSS Over 14 years experience integrating databases and the internet! On 8/26/08 1:58 AM, "barbpassman" <[EMAIL PROTECTED]> wrote in whole or in part: > 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
