Yes, I saw that option. But my table have 45 fields and they have very long field name. Just call me lazy ;)

I've found a work-around. I created an updatable view and appended the records to it. Work like a charm.

Thanks for your help.

>That is because you are probviding a value with append from. You cang et you default value to work if you APPEND FROM FIELDS ... and list all fields EXCEPT the primary key field.