I have a couple of suggestions:
1:
When a form’s table is updated, the form should be refereshed immediately, the way a data view with a live query is. My Reports form has the list sorted by Seq number field. It’s working, but when I pull up a record and change the Seq value (in order to re-order the list), I have to leave the form and then come back to it to see the changes. This is workable, but not intuitive. This is the very reason I had to create my own form page based on a Data View, because I added action buttons to “choose all” and “choose none”. The Join page just looked funny when I tap the “choose all” button and nothing seems to happen. Same when I re-sequence the list.
2:
Did you ever decide to implement MySQL’s innate ability to have a calculated field? This has been available since version 5.x and works very well. Five requires a bunch of code and functions in order to update fields which are part of the data needed for a calculated field. Example: Address is calculated by concatenating Street, City State and Zip, plus some punctuation. This is fine if maintaining the table via form, but not so good when updating the table via SQL.