Relations are a major pain
Save to folder
I spent the last week trying to figure out why my multi-page pageframe form, with a different table on each page, crashed when I moved to a particular record or when I tried to add a record to a table. I was using a database with six tables and five relationships.
Today I removed the relationships and replaced them with filters. Everthing works great now. I can even put my child tables in order by a name or date field instead of the primary key field.