I have created a table (1:1 opp).
I use a form to show the details as well as a few calculated fields.
The problem is the calculated fields will only work if the fields they are based on contain values. If they are empty, the calculated fields won't work.
Is there any way of inserting default values?
Apparently, the only way is by hard coding the form itself.
What would the logic (and code) be to create those "0" default values?
In SQL Server Management Studio, you can set a field property called "Default Value or Binding." This way the default value comes from the database table itself, as new records are inserted.