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:
|Mem ID||Last||First||Last 2||First 2||Address|
|Mem ID||Comm ID||Type||Desc||Phone||Email Reports?|
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.