Hello -
I can't seem to figure out how to change the order in which table records are displayed in a form. I think they are being ordered by the ID# (primary key???) by default. I can choose to sort from within the form by field (Last Name), but I am trying to automate that process so that the records are displayed by Last Name as the default.
Any ideas?
[Solved] Change order of displayed records in form
-
- Posts: 13
- Joined: Mon Jan 12, 2009 7:27 pm
[Solved] Change order of displayed records in form
Last edited by Chichomang on Wed Jan 28, 2009 6:18 pm, edited 1 time in total.
OOo 3.0.X on Ms Windows XP
Re: Change order of displayed records in form
Right-click the form>Edit...
Get toolbar "Form Design" and call the navigator from button #5.
Get the form's properties, tab "Data"
Change content type "Table" with content "TableName" to content type "Sql" with content
Turn off design mode (button #2 on toolbar "Form Design") and if the form works well store it into the database container and then store the database document as well.
Get toolbar "Form Design" and call the navigator from button #5.
Get the form's properties, tab "Data"
Change content type "Table" with content "TableName" to content type "Sql" with content
Code: Select all
SELECT * FROM "TableName" ORDER BY "Last Name"
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 13
- Joined: Mon Jan 12, 2009 7:27 pm
[Solved] Re: Change order of displayed records in form
Thanks buddy. You're the best. Sorry it took so long to get back to you...
OOo 3.0.X on Ms Windows XP