I have several questions related to sorting.
Is it possible to sort records within a record? I have a base that is a school directory. We have fields that indicate types of volunteer activities someone may be willing to do. We therefore have the interest name and it has a multiple links to parent names. I have not found a way to sort the multiple parent names that are linked to the record (unless manually).
Similarly, I have the parent names in first name and last name fields but the primary field is a formula that has the full name with first name first. Any way I can sort by last name even though the formula is first name last name? Obviously on that table it could be sorted by the last name field, but I have a linked table, and so it is the full name that appears, which would then sort by first name.