John,
>There are times when I do not want to use all of the fields (columns) when displaying and updating data. For example the Customer table has two dozen fields, such as CustomerID, Name, phone, address, etc. But I want to only use three fields such as CustomerID, CustomerName, AccessCode to display in a grid and have the user be able to only update the AccessCode while all other fields to remain unchanged. What recommendations are there for how to setup the Business Object or do I need multiple BO's one with all of the fields and one with just the three fields? Should I setup multiple stored procedures or views to retrive only the fields I want?
>
>Also all of my tables in MS SQL have the time stamp field that I never want to display or manipulate. Should I just uncheck it during the BO generation and it will be ignored?
>
>Thanks for any advice as I am new to MM.net and just leaning about BO's.
>
>John
You do not need to create different business objects. Just simply either use a specific stored procedure or specify the fields in your select statement. I often retrieve just a few fields into my list for display purposes.
Tim
Timothy Bryan