Is it possible to sort a portal on a looked up field.
I have a portal with names and forenames being looked up, but when I specify a sort on these fields nothing happens.
Yes, you can sort on a field that is lookup field. If it is not sorting properly, you may want to review your relationship with the table occurrence of the portal and confirm the field being sorted on is in the same table occurrence.
Thank you for confirming that I can sort on lookup fields.
I have checked the portal and all fields/sort fields are on the appropriate table.
Can you post a screenshot of the relationship between the tables, and the sort dialog of your portal? It might help us identify what the issue is.
The tables are as follows. The main layout is based on Course Classes and the portal from Student Registers.
The portal sort is as folllows:
The other part of the model, not used by this layout is as follows:
Ok, i think i have found it.
I just checked the field definitions for my lookup field, the result was set to 'Number' not 'Text'.
This seems to have solved it. Sorry to waste your time.
Probably a very basic error - I am a beginner at FileMaker.
thanks for your help.
Self-discovery is the best way to learn about filemaker. There is no need to apologize, and we're glad to assist growing other developers in the community!
Retrieving data ...