Hi - new to Knack but not to app development. I'm trying to do something that should be simple, but can't find a way to do it. I have two objects: Provider and Service. They have a many-to-many relationship: A Provider can offer several Services and a Service can be offered by many Providers. In this case, I created the connection in Knack from Provider to Service. What I want to do is create a list of all Providers with the Services each Provider offers. This is fairly easy to do, but the order of the Services as they are listed per Provider comes out somewhat random. I would like the order to follow a meaningful sequence. I added a "Sort Order" field to the Service object and changed the Service object's settings to sort on the "Sort Order" field. That does sort the Service records when looking at the Service object, but it does not sort the Services per Provider on the page with the list in it. There does not seem to be a way to set the order in which connect objects will appear in a list.
Is there a way to do this that someone knows?