I have created a one to one payment table, off of the SalesLogix Opportunity table, to store payments details.
I use a form to show the payment details as well as a few calculated fields (total payments, exact sales , etc…).
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?
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.