ALTER TABLE ORDER BY

[Matt W]

Can anyone possibly tell me why this would not work:

ALTER TABLE PARENTS ORDER BY PARENT;

With of course PARENTS being table and PARENT being field.

Am I seeing something wrong.

 

[John Vinson]

Can anyone possibly tell me why this would not work:

ALTER TABLE PARENTS ORDER BY PARENT;

With of course PARENTS being table and PARENT being field.

Am I seeing something wrong.

Yes. You're assuming that tables have order. They don't.

Use a Query rather than a table datasheet if you want to see records
in a particular order.