NWF Auto-Insert

[rupertvz]

Hi Guys,

I have one NWF that inserts a record automatically in the database, even when the form is cancelled by the user (without capturing any details)

I've checked all settings on the form and can't seem to find the reason why this form does auto-insert.

[rupertvz]

After a bit of digging, I discovered that the auto-insert is caused by one specific field being primed.

After removing the primed value, the form no longer auto-creates a new record.

I am still not sure why this happens, I will in the meantime code the prime value.

[terryd]

Hi rupert.
If you are using MSSQL the application will prime any field which is part of a unique key.

[Bruce]

Hi Rupert,

a) do you have an auto-number field in the table?
b) are there child tables (browses) on the form?

cheers
Bruce