Hi all,
I am completely a beginner in Filemaker and PHP API.
Now I am working with an unstructured FM database, contain almost 1000 records and 32 fields in each record.
Image below is describe the table, just only 8 records.
I need solutions
1. I want to perform a newFindAllCommand, and to make it faster (event only get 25 records), I'd like the 'find command' only load id, department and first name field. Sometimes I got:
What command to use when I want only select 3 required fields rather than 32 fields ?
In SQL I can do
2. If I want to get the department name only, just want to list available 'department name' in the table, which result like:
How can I do this, while in SQL I can use 'group by' :
Thanks
