Learner1 Posted July 20, 2007 Share Posted July 20, 2007 Hello, 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 More sharing options...
Vaughan Posted July 20, 2007 Share Posted July 20, 2007 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 More sharing options...
corn Posted July 20, 2007 Share Posted July 20, 2007 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 More sharing options...
Learner1 Posted July 20, 2007 Author Share Posted July 20, 2007 Thank you to both of you for your advice. I actually do need to seperate the 2 entities into 2 tables. It's the graph that was confusing me. thanks again ;) Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6252 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 accountSign in
Already have an account? Sign in here.
Sign In Now