AnsweredAssumed Answered

Create a list of dated entries from a single field

Question asked by willrollo on Sep 16, 2012
Latest reply on Sep 17, 2012 by willrollo

Title

Create a list of dated entries from a single field

Post


     Let me explain...

     I have a field in a customers' table called "Notes" (customers::notes)

      

     This field is to obvioulsy add notes about the customer. I have created a button that will automatically add an entry to this field:

         
  •           Set Selection [ Customers::Notes; Start Position: 0; End Position: 0 ]
  •      
  •           Insert Text [ “ ” ]
  •      
  •           Set Selection [ Customers::Notes; Start Position: 0; End Position: 0 ]
  •      
  •           Insert Calculated Result [ "--- " & Get(CurrentDate) & " by " & Get(AccountName ) & " ---¶" ]

      

     What I want to do is have a layout where the user can enter a to and from date, to display all notes that have been added between the two.

     What is the best way to go about this and what alerations should I make?

      

     Thank you

      

Outcomes