How do I use a secondary index to sort records displaying in a form?
I have a 4 field Base table: ID - Integer/PrimaryKey/AutoValue; Type_ID - Text fix CHAR; Type_Name - Text VARCHAR; Type_Notes - Text VARCHAR
The system created an Index on the PrimaryKey ID field. I created a secondary index on the Type_ID field. I created a simple form to maintain the table records. I need the records to display using the secondary index order, not the system created index order.
I'm a newbie to Base. Thank you in advance!