Create new record in SQL

HI

Is someone working with FM9 and a SQL Database ?

I link FM9 with a SQL Table, then I display those data into a layout, when
creating a new record, FM create a blonk record with all those autodata
entry that my SQL data require... the only think it's not creating it's the
new row in the SQL Table, so when I commit the record I get and error
message

Line 1: Incorect syntax error near "output"

I manage to narrow it down to ... the key row is empty... FM is not
"creating" a new row in the SQL table and the relationship is not there.....

The only way I have found is to send in a script the "Execute SQL" with the
INSERT command in it.... but that doesn't create all the default data that I
need
Unless I use the INSERT command with all those field data... and not using
the easy "create auto-enter" data from FM

Anyone have an easy solution ? or maybe it's something I'm missing in FM ??

Thank you

JF