Can anyone point me to dynamic sort examples.

I have a large number of tables and i need to script sorting for each.

• I do not want to use the built in dialog as it is too open to abuse.

• Performance is a key consideration.

many thanks

Stuart

What kind of abuse comes at the hands of the Sort dialog? I must profess my ignorance of the issues it causes.

I just don't like people having access to the internal contents of my files (hidden fields and relationships). I realise you can show only layout fields but this does not stop user access to the rest.

I also like my users to be able to sort in the way they would expect via any other application.

Column sorting and popup list choice.

The filemaker dialog is ugly and requires explaination. My users expect a polished solution and thats what i prefer to give them.

Its just the way i prefer to work.

examples of abuse…

1. A staff table may store many different forms of information. Salaries, Bonuses, etc.

a member of accounting staff may have access to the total spent on salaries for a given period which would be a total of the values.

Although they do not see the value, there privileges would in fact allow the calculation to use it.

The sort dialog would allow the user to sort staff members by salary.

This is confidential information, although the user does not see the specific information, they do see who gets paid the most in order.

Disallowing access to the dialog prevents a standard user from performing such actions.