>>How do I get properties such as defaultvalue to work with views?
>I am not sure but I believe that since the view is actually based on a table, it should assign the default values when adding new records if the table is in the database and the default values have been assigned to their respective fields. Let me know if I am wrong.//:^)
Check DBSETPROP() function which should allow to set DefaultValue property for a view.
Edward Pikman
Independent Consultant