SQL and Infopath

[Seb]

Hi all,
I have a form in Infopath connected to a SQL backend with several tables.
Each table includes a few required fields. The problem I'm having is that
Infopath insert a blank record in each table even if nothing is filled out in
that particula section and even if the field is marked as required in the
table in SQL for some reason Infopath is still able to add the record with a
blank value.

Any suggestion will be greatly appreciated as I am running out of ideas here.

Thanks all