General

Re: Sort repeating section

Greg Collins — Wed, 09 Aug 2006 17:32:36 GMT

Glad to have helped!

Re: Sort repeating section

Carlos — Tue, 08 Aug 2006 00:11:06 GMT

I have done the sort in SQL which solved the problem. Many thanks.

Carlos

Re: Sort repeating section

Greg Collins — Mon, 07 Aug 2006 17:20:09 GMT

Go to your data connection wizard, and there's a place where you can Edit SQL... this will allow you to place an ORDER BY statement in the SQL code so that your rows are ordered by the database before you ever get them in the form.

Re: Sort repeating section

Stavi — Mon, 07 Aug 2006 11:48:08 GMT

If you setup a button to save new entries and query main connection in one go then the records would be re-sorted as per your data connection

Sort repeating section

Carlos — Sun, 06 Aug 2006 02:57:55 GMT

Hi all,

I have a form (based on SQL 2000) which has fields from a table and also another repeating section within that repeating section. Below is what SQL is looks like:

Project - Project_ID, Person_ID, etc
Person table - Person_ID, Project_ID, name, role_id, RL_ID,
other fields
Related_Project table - RP_ID, Project_ID, Project_Name

Now I need to sort the Person table (on page load is fine) on the role-id field. This field contain a number as the key field. So, when creating multiple persons, each will have a role, some of the records have same role. What I want to do is resort so that they are grouped together, rather than having different roled mixed up as they are entered on the day, as its very hard to find a role this way.

So, my forms are VBSCRIPT, and just needing some direction as to what code would be required to do this, if it can be done at all.

Many thanks,