I have to move some tables to SQL back end and I have good knowledge of this however there is one oddity I would love advice on.
Currently I have 4 interface FM files that all link to a single database FM file.
The 4 files a 4 separate modules but the do share some tables from the main db, especially for value lists etc.
1 - I could re link the fm database file to the ODBC SQL and leave the font end files linking to the FMdatabase file
2 - I could link each of the 4 files directly to the ODBC SQL.
Not sure which would be right or wrong.
I know with option 1 I have only 1 place to manage shadow tables, auto enters etc so that would be my favourite but im worried that piggy backing might slow things down?