I have a fairly simple portal that the first field is a quantity. When I enter a number in a new row and tab to the second field the number is reset back to zero. If I click back in the field and override the zero it is fine. It is like when I tab to the next field that the record is created and then it sets a default value.

I have checked and there is no script triggers on the portal, the quantity field

There is no default value for the database field.

Scratching my head.

Thanks

Thom

you can do a scipt trigger to commint upon entering the first field that should force the creation of the record, or a commit trigger after you enter a number.

I would like to see a stripped down sample of the database to give you a better solution.

Script triggers are NOT the solution to EVERY problem. Sheesh.

Work out why the field is changing back to zero. It should not be doing that.

If I open Script Debugger and then tab out of the field then nothing is running and the field returns to 0. Any other trouble shooting you can think of?

I'd start with checking the relationship.

If you are sure that the field does not have auto-enter data of 0 or auto-enter calculation then it might be field-level formatting.

Inspector > Data tab and Data Formatting. If the number format is anything but 'as entered' or default (set to Boolean for example), this could explain it. Are you sure it is the correct field? Please don't take that wrong ... sometimes I get tripped on this particularly if I've copied another field and then re-specified it (sometimes I forget).

It is strange indeed. As Vaughan says, even if a related record, if User is able to enter the field and change the number, the number should stick.

If I open Script Debugger and then tab out of the field then nothing is running and the field returns to 0. Any other trouble shooting you can think of?

Zip your file and post it to the forums.