Asking really basic questions I know but just trying to figure this stuff out.
I just downloaded Filemaker's new CRM sample app. What is going on with this zz_Match global field and its use in the relationship graph?
Which field are you referring to?
Thanks for pointing that out….I just edited it but you beat my edit.
The zz_Match field.
The main file zResource and the field zz_Match have Cartesian joins to the other tables (TOs). I’ve not studied the file yet. Do you see portals based on any of these relationships? Are the further filtered in any way?
Sent from miPhone
Given the "x" symbol in the relationship line, it means that the relationships are 'cartesian' relationships. Using the relationship will show all records from the related table (as opposed to just related records that you'd see through a normal "=" relationship.
In essence, it doesn't matter what value you put in zz_Match. FM are going to show all records from the other side anyway.
Looks like it is primarily used for the dashboard of the CRM. Each portal has another filter related to currently logged in user. Starting to make a bit more sense why you would do this for a dashboard.
Retrieving data ...