Jump to content

One-to-one relationships

This topic is 6181 days old. Please don't post here. Open a new topic instead.

Recommended Posts


I have searched the file maker 8 user guide and many websites but can't find any thing about one-to-one relationships in filemaker. Does anyone have an idea about how I can set this kind of relationships.

Thanks in advance ;)

Link to comment
Share on other sites

One to one relationships aren't very useful. An example:

We have a bunch of information about "People". We also have "unique ID numbers" of which each person can only have one, and each ID number can only be associated with one person: a typical one-to-one relationship.

One-to-one information could be kept in a separate table, but because it's never duplicated, and there must always exactly the same amount of ID numbers as there are people, it's easier and more correct to store the IDs in a field in the same table. Hence, information that exists in a one-to-one relationahip is about the same entity and needs to be in the same table.

Should you be asking about one-to-many or many-to-many rekationahips? These are useful and interesting (particularly m2m).

Link to comment
Share on other sites

I'll have to disagree with Vaughn about 1:1 relationships. They are both useful and appropriate in FMP.

Specifically, 1:1 relationships are used for optional attributes about an entity (e.g. not every employee drives a car to work so attributes about the car make, model, color, and marker plates would be stored in a separate table). They are also used for representing supertype/subtype relationships.

In supertype/subtype relationships I prefer to use the same primary key for both tables, allowing auto-create through the relationship for population of the primary key in the subtype table.

Their setup is fairly straightforward. Don't be confused by the graph though; those lines and crows feet don't necessarily represent the relationship type you see.

Link to comment
Share on other sites

This topic is 6181 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.