FM9 and SQL

Me again, I haven't got the awnser yet of my question....
.......Je peux également expliquer ce probleme en francais


I have a Customer SQL database (and I don't want to be able to add data via
FM, read only)

Also in FM I have a list on customer (we call them Cash Sales) information
on them but no account with us, so they are not in the SQL database.

When working with FM9 I need to combine both database into a single "table"
of layout....

by that I need to have only one customer layout that will display from
either SQL or FM.

In the past I was using importation ODBC and I was creating new data and SQL
data have a row number to link FM to SQL for the next update and the "Cash
sales" have the field set to "EMPTY" so by script you can remove the "EMPTY"
records so no conflict will occure during update. So I have 3000 record in
SQL and 6000 cash sales in FM for a total of 9000 records in my FM Solution

Now with FM9 I have add the SQL Table into FM and it's GREAT !! but with my
"cash sales" I have not found a way to mix that into my solution.

When displaying a table from SQL, all the 3000 records show in my found set

I think about a 3rd table that will be a calculation to display data from
SQL
or FM, Now I'm displaying that table into the layout and I have a
calculation table with
If (CashSales_ID=EMPTY ; SQL_DATA ; FM_DATA)

BUT ! it's not working... I need to add record to have the list of all the
9000 records
and when adding new record in SQL, FM won't be updated

Anyone have a solution for me

Thank you

JF