How to export records from different tables to one txt file
I am using file maker pro 11 ...new to File maker pro as well as designing database.
I defined fixed length fields (by setting maximum number of characters on the validation options) on different tables.
Here are the difficulties I am having:
1. I want the contents of records from different tables to be exported into one text file including null values. meaning, if I don't have any value in any of the fixed length fields, I want those fields' contents to be seen as blank space on the txt file. How do I do it?
2. How would I be able to append records from different tables in one txt file? I don't want the records to be appended by page. what I want them to be, is just to be appended next to the previous exported record value.