>Is there no way to add a record without having to fill in ALL the field
>values?

When you add a record, all fields have to have a value. if you don't specify one in the insert statement, the default value takes effect. If there isn't one configured, then the field is set to .NULL.. This is true if you use ADO to insert it or if you are in VFP (if VFP tables) and use the Command Window.

There is no way around it.