Usually to sort a Form in a particular order you go to the forms section and within the SQL write a statement showing the information in descending order.
I have a subform however and the subform does not appear in the forms section.
Fine I can go into objects and select the subform here and I note that there is a tab called display and on selection it has a SQL box.
I am wondering whether I have to define the SQL in a specific way so it that it not only arranges the sub records in a descending date field order but also filters out only children of the parent form.
Could someone who know more maybe give some air code or give some guidance?
Many Thanks
Mark
Welcome to the nuBuilder forums!
Please register and login to view forums and other content only available to registered users.
Please register and login to view forums and other content only available to registered users.
Sort Sub Form in Descending Date Order
-
- Posts: 40
- Joined: Thu Jun 23, 2016 10:33 am
- Location: Edinburgh
- Contact:
-
- Posts: 40
- Joined: Thu Jun 23, 2016 10:33 am
- Location: Edinburgh
- Contact:
Re: Sort Sub Form in Descending Date Order
My first thought was I just completely omit the select section of of the SQL and simply place in Order by clause
That didn't seem to work
Code: Select all
ORDER BY DATEUPDATED DESC
My Blog - cloudydatablog.net https://cloudydatablog.net/
-
- Posts: 40
- Joined: Thu Jun 23, 2016 10:33 am
- Location: Edinburgh
- Contact:
Re: Sort Sub Form in Descending Date Order
Apologies discovered how to do it.
Access Sub Form via Objects button.
Go to Subform tab and here you will see the entire SQL already defined.
Alter the SQL as required.
Thanks everyone for brilliant and easy product
Access Sub Form via Objects button.
Go to Subform tab and here you will see the entire SQL already defined.
Alter the SQL as required.
Thanks everyone for brilliant and easy product
My Blog - cloudydatablog.net https://cloudydatablog.net/