登录
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Field history

Răspuns Field history

  • 2008年4月29日 9:31
     
     
    登录进行投票
    0

    Hi

     

    I have a question, I made a field SQl type, and i have to keep a history of upgrade changes, for example i sold to a customer in january sql standard edition and in november i upgrade it to SQL enterprise.Next year in may he bought from me SQL enterprise 2008, I want to make a report in which to see the evolution of SQL of this customer

     

    Thks very much

     

全部回复

  • 2008年4月29日 10:16
    版主
     
     已答复
    登录进行投票
    0

    Hi,

    A simple solution will be to add a read-only text area field and append your SQL history to it using JScript.

    Another solution will be that most probably for each sale and upgradation you will be recording a new order with same customer. So your order history should be able to explain the history. You may just need a SRS Report to summarize it.