3 Replies Latest reply on Sep 17, 2012 6:32 AM by willrollo

    Create a list of dated entries from a single field

      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