AnsweredAssumed Answered

Need Hints for Exporting Data to Excel

Question asked by rmittelman on Jun 9, 2014
Latest reply on Jun 9, 2014 by rmittelman

I'm not sure if this is a question for General forum or Sharing Data forum, but here goes:

 

My membership database needs a functionality to export records to Excel. The database used to be in MS Access, and I had VBA methods to query the proper data, then using Excel automation, create the workbook and simply write the data records into it, then save the workbook.

 

Now that I'm using FMP, this is not going to happen. So I need a couple of pointers.

 

Here is the basic architecture:

 

Members table:

Mem ID
LastFirstLast 2First 2Address
27SmithJohn
Julie

 

Communication Table

Mem IDComm IDTypeDescPhoneEmailEmail Reports?
27331John Cell8055551212

27342John
John@me.com1
27352Julie
Julie@me.com

 

So here are the questions:

 

1: Do I need a "report" type layout, or a "list" type layout, or doesn't that matter?

2: I guess I base the layout on the communications table, then include fields from the linked Members table, right?

3: Once I have the layout designed and sorted / filtered, I'm guessing I can simply script the export, right?

 

Thanks for the help.

Outcomes