How do I set a default sort for a related list

[xiyan_li]

Can someone tell me how to set a default order for the data in the related list on the table form, so that when any user opens it, the order I set is displayed.

I would appreciate it if someone could tell me the answer

[MG Casey · Accepted solution]

You'll want to create a Relationship instead.

System Definition > Relationships

In the "Query with" section, be sure to add in your desired orders.

Once defined, you'll see this as a new option when you go to configure your Related Lists on that table.

[MG Casey · Accepted solution]

You'll want to create a Relationship instead.

System Definition > Relationships

In the "Query with" section, be sure to add in your desired orders.

Once defined, you'll see this as a new option when you go to configure your Related Lists on that table.

[xiyan_li]

Because my related list is actually done in the system UI -> Related List, do I need to create another related list in System Definition > Relationship

[MG Casey]

Yes, correct. If the ordering is that important, you'll need to make a brand-new Relationship record.

[xiyan_li]

After creating the relationship-related list, click the [new] button at the top right of the relevant list. After creating a piece of data, can the data be automatically associated with the Relationship

[xiyan_li]

Thank you very much, I have created a new Relationships and implemented my function