External Tables and Relationships
I typically design a database using external FM tables to hold records. My "working" database file usually only contains layouts, scripts, lists, etc. and no tables. In the past, I have had no problems setting the table relationships in my "working" database. My layouts, and simple portals work without problem. As I have gotten into more complicated design, I was wondering if there are any limitations to working with external FM files in this way.
1. Are there any limitations to working solely with external FM files?
2. Would there ever be any need to create relationships at the external table level rather than in my "working" database?