FM9 and SQL

Hi

I post that many weeks ago, but never quite get an awnser....

I have FM6 right now and I use PDM SQL plugin to retreive info from my SQL
database and I also Import ODBC to keep my FM database up-to-date with
SQL... now with FM9, I won't need that plugin and those long lines of coding
to request info in my SQL database....

my problem is that I have in FM a customer list that have to field
FM_Unique ID number and a SQL_Row Unique number (and I use that ID to link
that to the SQL database)

That is great if I only have in both database the same information.... but
in my FM Database I also collect information on customer that we call "Cash
Sales" and there names are not in the SQL database so there SQL_Row in my FM
Solution is set to "EMPTY" and when I update the FM Database I remove all
the "empty" record because they can't be sync to the SQL database, and I
only update the data with a valid link from FM to SQL......

Now that I can link SQL like anyother table in FM9.... how can I have 1
Table for customers that will have live data from SQL and also FM data ???

Right now the only solution that I have is:

Table1_SQL
Table2_FM_CashSales
Table3_Customers_List (and that 3rd table will be a calculation only, that
will take info from table1 if data is created to be from SQL or display
result if created for CashSales FM internal only....)

Will this create complex problem because I need to link many tables and
customer have contract, maintenance, equipment, etc etc....

Thank you
JF Fortier