4 Replies Latest reply on Jul 11, 2012 12:36 PM by BillBoyd

    Add External Table to Relationship Diagram?

    BillBoyd

      Title

      Add External Table to Relationship Diagram?

      Post

      As I mentioned in other posts, I'm trying to reimplement "Business Productivity Solution - Services Edition" in order to (1) avoid a problem with missing text in forms and (2) tailor it more closely to what my client needs.  I've made good progress, but I'm stuck on one item: How do I add a table in one physical file to the relationship diagram of a table in another physical file?  On page 126 the User's Guide says, "To set up a file to access data from another FileMaker Pro file: Add tables from other FileMaker Pro data sources to the relationships graph in the current FileMaker Pro file."  However, it doesn't explain how to do that.  I tried using File > Manage > External Data Sources and an external file now appears in the panel "Manage External Data Sources", but that didn't cause the external table to appear as an option in the "Edit Relationship" panel.  What's the secret?  Thanks for any help.

       

       

       

        • 1. Re: Add External Table to Relationship Diagram?
          philmodjunk

          Don't know if you knew this already or not, but the "boxes" in Manage | Database | Relationships are called "table occurrences". You can have many occurrences of the same table if such are needed for your solution.

          In Manage | Database | Relationships, click the button in the bottom left corner. This creates a new table occurrence and you can then select an existing data source table from the drop down of available tables for your new occurrence in the dialog that opens when you click this button. If you had not already gone to Manage | External data sources and created the external data source reference, you could have selected Add FileMaker Datasource to create one. Since you have already done this, you should see the tables from this external file included in the list of available tables.

          • 2. Re: Add External Table to Relationship Diagram?
            BillBoyd

            You've saved me again.  Your advice was just what I needed.  I'm not sure how to explain why that didn't occur to me.  I'll guess I thought the "Add a table" button was intended to create a new table rather than to add an existing table occurance to the relationship diagram.

            By the way, do you know why a number of the tables in the "Business Productivity Solution" files have data elements (such as "ID" fields) that are defined as "text" and as "Serial Number on creation"?  I would think that anything that holds an auto-generated serial number would be a number rather than text.

            • 3. Re: Add External Table to Relationship Diagram?
              philmodjunk

              Whether or not a serial number field is defined as text or number is the preference of the developer. Like you, my preference is to put numbers into a number field--you never know when you might need to sort on that field and numbers in a text field don't sort correctly. But as far as uniquely identifying records in a table for use as a key in a relationship--either field type will work.

              • 4. Re: Add External Table to Relationship Diagram?
                BillBoyd

                Belated thanks for the explanation.  That confirms what I suspected.