Apache OpenOffice Community Forum

Posted: **Fri Jan 23, 2009 8:47 pm**

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?

Posted: **Sat Jan 24, 2009 1:07 am**

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

Code: Select all

SELECT * FROM "TableName" ORDER BY "Last Name"

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.

Posted: **Wed Jan 28, 2009 6:18 pm**

Thanks buddy. You're the best. Sorry it took so long to get back to you...

Apache OpenOffice Community Forum

[Solved] Change order of displayed records in form

[Solved] Change order of displayed records in form

Re: Change order of displayed records in form

[Solved] Re: Change order of displayed records in form