Has anyone ever done this or have any idea how this could be done? TIA
I've done it twice. I'll double my hours estimate for the next one...
:-{(
It's possible to import the table data into Access, with some
difficulty: FMP tables typically contain calculated fields which must
be skipped in the import, they don't come over correctly. You'll need
to write Queries to redo the calculations.
The FMP user interface - forms and reports (which are really pretty
much the same thing in FMP) must be rebuilt from scratch. There is
little or no similarity in the underlying structure of these tools.
Typically FMP tables will require considerable restructuring to make
them properly normalized, since FMP doesn't actually support standard
SQL or relational integrity.
