2 Replies Latest reply on Nov 12, 2008 3:06 PM by blackcat795

    "Allow Creation of Records via Relationship" not working

    JYM

      Title

      "Allow Creation of Records via Relationship" not working

      Post

      We have a master table with four separate fields used as a combined key. We have created a relationship to a child table using these four fields as join fields in the relationship. The option to Allow Creation of Records via This Relationship has been selected in the child table. When there was a small amount of data this seemed to work as expected, now the database has grown larger, it does not create the related record despite being selected as an option.

       

      We see this behavior consistently.There are many separate child tables, all of which need to have records created when there are records added to the master table. If anyone can shed a light on this problem, that will help us a lot. We've been trying to 'rebalance' the child tables manually and that's been a grueling task :smileysad:. Is there a configuration we have to set explicitly? Has anyone encountered similar problem? 

       

      This message is also added to bug section of the forum.  

       

       

        • 1. Re: "Allow Creation of Records via Relationship" not working
          TSGal

          JYM:

           

          Thank you for your post.

           

          I have several files with multiple keys (some with 2, some with 3, but none with 4).  In each occurrence, I'm able to add a record to the child table when no information appears in the portal once all key fields are entered.

           

          I created a new database with two tables having four key fields (aptly named field1, field2, field3, field4), and I'm able to add without a problem.  I know you said this worked fine with a small set of records, so could you provide me the number of records in your tables?  I'd like to try and duplicate the problem and see if there is a problem within FileMaker Pro.

           

          There will be an identical response to your post in the bug section.

           

          TSGal

          FileMaker, Inc. 

          • 2. Re: "Allow Creation of Records via Relationship" not working
            blackcat795
              

            JYM

             

            If your system works on a small amount of data but fails on on a large set then I would suspect that the way your larger data set is handled is the issue, check the way your child data is created & double check if the info in your relationship combined key in all new records to be processed are consistant.

            I am guessing you will find that there is some data missing from your relationship combined key field therefore a relationship is not being made.

            It only takes one bit one bit of info in your relationship field to be different to cause an issue, check spcecifically for spaces at the end of your relationship fields for each record (sometimes users accidentaly add extra spaces that are not always easily visable).

            A nice quick check method would be to use a calc field Length(relationship field) to compare relationship key against new data relationship key data side by side on the same layout. Ones that dont have the same number will your problem data records.

             

            Any system will always handle the data the same way irrespective of ammount of data if no design changes are made to the system.

             

             HTH

            Let us know how you get on

            Blackcat