Normal Topic Sorting records in a subform. (Read 1209 times)
NHUser
Full Member
***
Offline



Posts: 320
Location: Amherst, NH
Joined: Aug 2nd, 2010
Sorting records in a subform.
Sep 13th, 2018 at 8:52pm
Print Post Print Post  
I have a form with a subform.  I expect the number of records in the subform to be quite large and i'd like them to display in alphabetical order.  Is there an easy way to do this so it occurs automatically?
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Sorting records in a subform.
Reply #1 - Sep 14th, 2018 at 2:14pm
Print Post Print Post  
Hi Paul,

With the parent form open, in the spec window in the lower left, switch to the Sort spec for your subform. Set the sort that you want. Open the Spec Manager, Save the sort and set it as the default. This saves the sort spec of the Parent and Child forms and they will be used as the default Sorts.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
NHUser
Full Member
***
Offline



Posts: 320
Location: Amherst, NH
Joined: Aug 2nd, 2010
Re: Sorting records in a subform.
Reply #2 - Sep 17th, 2018 at 9:08pm
Print Post Print Post  
Thanks, Ray

It works great!  Just what I needed.
  
Back to top
 
IP Logged