Hi, what is this means in relation?
It means that every record is related to each other.
It's not really a relationship but just links to all records.
it is called a cartesian join - gives you access to all records on both sides for all records on other
The "tee" connectors also indicate unindexed fields--often global or unstored calculation fields.
One comment is that i usually see these cartesian connections using key fields and the name "Status Order" does not seem like a key field.
In terms of relationship function the match fields don't matter in a Cartesian join. You can even delete the match fields from their tables and the relationship still works.
There are cases where using a particular field as the match field makes it easier to update filtered portals that use that relationship, however.
I want to use one of FM project (Invoices) and make changes to use it but I don't know about this relationship ever
Then it would help us to help you if you:
a) told us that this was what you needed first.
b) told us which starter solution and which version of FileMaker it came with.
c) told us which feature that you want to emulate in the starter solution is based on it.
d) showed us more of the relationship graph so that we can put it in context within the other table occurrences.
Filemaker 15 pro advanced
I listed four things, you provided 2. I can deduce the fourth, probably, by opening my copy of the starter solution and looking at it. But that leaves item c) with no response from you.
The X is a special relationship you could call "iCloud".
Let's say you have an iPad and 2 iPhones.
with a normal relationship, when you jack around with one of these devices, you will only see the photos you captured with that specific device.
By using iCloud, no matter which device you use, you will see all pictures captured with any of your devices.
That's a Cartesian Join.
Retrieving data ...