Relationship graph question

[jimlongo]

Hi, I'm very new to managing more than 1 table.

I have 3 tables. I want them to be connected by an ID

I've started with a FM template and modified to suit my purposes. Here is a picture of that relationship graph.

I've started a new database and copied the relationships between the tables as in the template. But my relationship graph doesn't have the "trident" symbol.

Where does that come from and what does it mean?

Thanks,

jim

[David McQueen]

Filemaker tries to intuit if the relationship is one to one or one to many. The trident is just its way of indicating what it thinks.

No it does not affect the relationship and No FileMaker is not omnipotent -)

[comment]

my relationship graph doesn't have the "trident" symbol … what does it mean?

As David said, it means that Filemakers consider the relationship to be a one-to-one. There is a reason for this, and most likely your relationship is NOT set up correctly.

In a one-to-many relationship such as Employees -< Issues, the EmployeeID field in the Issues table (the "foreign key") cannot be unique. Your foreign keys are either validated as unique or auto-entering a serial number.

[jimlongo]

Thank You!