Exporting records of two tables with same fields into single file
It seems like what I'm trying to do should be easy and common, but I can't figure out a 'clean' method of doing it and I can't find any other posts where someone has tried something similar.
We publish newsletters. I have two databases that contain addresses (among other things). One contains our advertisers and the other contains residents. Currently, I have the addresses export into two separate files (per area) with a single script. Then they are both imported separately into the USPS software. I'm always trying to find a way to make things faster and it would save a lot of time if I could find a way to have addresses from both databases exported into a single file.
I think a lot of us wish FileMaker had a way of appending shortcuts. But until that feature is added, try importing both sets of addresses into a dummy table/database, then export from there. Depending on your FileMaker scripting expertise, you could have it set as a One-Button process.