Robert,
>Hello. I have an application where the users can input a $0.00 value. I've tried Numeric(10,2) and Money as the data types, but it still says it cannot save the dataset becuase Cost is required. $0.00 is a valid input value.
When generating your business layer, you can select your currency column in the Business Layer Generator and select the "Allow Empty Value" check box. This generates business logic code that allows an empty value for required columns.
Best Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com