insert datasets with tablegrid

[Heiko12345]

I wanted to enter new data records in a table using a table grid. Sometimes it worked and sometimes there were FK errors, although the values were contained in another table. Formulated as SQL statements, it worked without an error message.

 

[Marco Kalter]

After entering the data, instead of clicking on the "Post changes" button, can you click on the list button to the right of the "Post changes" button and select "Open in SQL Window" from the list? Now you can see the exact SQL statements that will be executed. Perhaps this contains a clue as to what might be wrong with the FK data.