Does any one know how to create a view that will use all the field properties that the original table has
Like the caption, default value ,format , etc…

All there properties are left in blank when you use the view builder or the view wizard, then you have to set them by hand one by one.