Create local views (or cursors) based on the tables and add records from tables in desired order (remember about 'All'). Link combos with cursors and set Sorted property to false.

>I have a form with 6 combo boxes. They are all populated by 6 different tables (operator,shift,customer,type,decription,colour). The form is used to collect all the criteria needed for a report.
>
>The problem is they now want an option to select "ALL", this is not stored in the table. Could you please give me any idea's how to do this. Also "ALL" needs to be at the top of the combo's.
>
>Thanks
>
>Nicky