1 Reply Latest reply on Jan 30, 2014 10:28 PM by symbister

    Sort within a repeating field

    TinaBrown

      Title

      Sort within a repeating field

      Post

           My database contains records for individual people.

           I do invoices on behalf of each person.

           Within each record are repeating fields where I add in when each persons invoices are due to be sent.  

           I would like to be able to sort within each record the repeating field so it shows to me in date order.

           ie 

           Joe Blow record

               inside his record I have a repeating field of when his invoices are due out

                       30/1/2014
                       5/5/2014
                       3/2/2014

           I would like it so the dates would be in correct date order.

           Thank you for your help.

        • 1. Re: Sort within a repeating field
          symbister

               Strongly recommend that you reconsider using repeating fields.

               Suggest instead that you have a related table set up - linked to your Contacts table with a unique ID:

               Contacts----------<Invoices (meaning one-to-many)

               Invoice::fkContactID = Contacts::pkContactID

               then your Invoices table will have data such as Inv Number, Date etc. and a portal on Contacts can display all invoices for that Contact in date order..