[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Filemaker Pro Relationhips

Posted on 2012-09-10
Medium Priority
Last Modified: 2012-11-15
I use FM pro 11. I normally create multiple table occurrences to create relationships. As a general question, is it a good practice to create multiple relationships with the same fields relating two tables, but that are to be used for different purposes?
Table A and Table B are related by customerId. I created two relationships using customerId on both tables. I use one relationship to go from one menu (Table A) to another menu (Table B) to view related records. I use the other relationship in a script to perform calculations.

I guess my main question is if having many relationships in a database causes performances issues in the database?
Question by:PachecoPrimo
1 Comment
LVL 25

Accepted Solution

Will Loving earned 2000 total points
ID: 38385025
If your two relationships are identical in terms of key fields, sort order, and other settings, then there is probably no need to have two relationships.

Without seeing a picture of your relationship graph and having a sense of which fields you are relating it's difficult to give s specific answer to you question, however, unless you get into very complex database structures and start doing things like pulling data across multiple relationships, you're unlikely to have any performance issues. In fact, it's quite common to have multiple Table Occurrences between two tables using various key fields in order to achieve various functionality and/or display goals.

An example, I have a "Timeslip" database that I use for tracking billable hours. From the Customers Table I have several relationships to the Timeslips Table. One is Customer ID to Customer ID, another is Customer ID to a calculated Customer ID field in Timeslips that only has the Customer ID if the Timeslip is not yet billed (thereby allowing me to see how many unbilled hours I have for that client).

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A lot of new and distinct gadgets are making their appearance every other day. The latest gadget that has wooed the attention of all gadget lovers and non gadget lovers alike is the Smartwatch. This tiny gadget is capable of offering live access to …
Is your phone running out of space to hold pictures?  This article will show you quick tips on how to solve this problem.
Users will learn how resize a batch of photos from a single command in Photoshop via Photoshop's Image Processor. Open up an Image you'd like to resize in Adobe Photoshop: Adjust the image size according to your preferences. Image > Adjustments > …
Users will learn how to set proper sequence settings, scale images, paste attributes, add transitions, fades, and music. Open up Final Cut Pro 7 and Create a new Project: Set the Sequence Settings. a) Click File > Easy Setup > Format > Apple ProRe…

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question