I'm hoping you can help me.
I am trying to migrate the data from a FileMaker pro database to MySQL, but keep FileMaker as the front-end. I am trying to either avoid having to re-map the calculation, global & summary fields or find an easy way to do the remap.
Just to explain the re-mapping problem... If you are linked to a database and you delete a field from the data source, it becomes <Field Missing> in the front-end. I want to add back in a new field which would be a calculation, field or summary, and will automatically link to the <Field Missing> without having to re-link it.
Thanks for any help