FileMaker Relationships – How They Compare

OK, I’M TALKING ABOUT TABLE OCCURRENCE relationships here, not the other kind.  Although those might get more hits…

Dwayne Wright explores the basic different types of relationships that are possible between two tables:

…there is a feature in the FileMaker define relationship dialog box, you can define what is a compatible relationship. For example, say we have a relationship between a clients table and an invoice table, the normal operator would be clients:client_id = invoices:client_id. The valid relationship would be when the data in the two fields equal.

With FileMaker 7 and higher, some of the OTHER comparison operators used in a realtionship can be …

≠ ( not equal )
> ( greater than )
< ( less than )
≥ ( greater than or equal to )
≤ ( less than or equal to )
x ( means all records in both table occurrence compare, no matter the data in either

≠ ( not equal )

Combine these basic operators to build more complex relationships. For example, you might want to show all invoices greater than a certain date for a particular customer in the invoice table.

Read the whole thing to get a better understanding of FileMaker relationships.

More…Dwayne Wright PMP, PMI-ACP, CSM – FileMaker Thoughts – FileMaker And Relationship Comparison Operators.

Liked Liked
Need FileMaker Development Help? Or to purchase FileMaker Software?
Contact FM Pro Gurus for help