Primary and Secondary keys in a table 1

[ronphx]

I am more curious about this than anything, because most indexing and sorting is done through queries, but in Excel you can sort a range by a primary and secondary field. Can you have a primary and secondayr sort field when you view an Access table or can you only sort one field at a time?

 

[PHV]

You may create composite index.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ronphx]

Thank you. That's it. How do I activate that index when I am viewing the table?

 

[PHV]

You have to know that in a relational database the rows of a table are in no particular order.
Only the ORDER BY clause of a SELECT instruction may arrange the result set in your expected way.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ronphx]

Thanks again. I use the select and order by statements when coding, but every once in a while I just want to click on the table and open it to view the contents in the composite order. Sounds like I'll still have to do a simple query to see the multiple sorted fields.