Filemaker Pro Relationhips

Posted on 2012-09-10
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 24

    Accepted Solution

    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).

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Suggested Solutions

    Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
    There is a security feature on iOS devices that is nearly impenetrable when it has been activated.  This article will provide some possible solutions as well as necessary steps to take to ensure you do not end up with a locked device.
    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…

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now