5 Replies Latest reply on Sep 12, 2014 9:04 AM by philmodjunk

    Annoying - form entry creates duplicate record



      Annoying - form entry creates duplicate record



      Got a problem that is driving me a bit nuts.

      I'm trying to input data into a record via a form. Everything seems to be set up properly, including the relationships.

      However, when I input data into a new record via the form, two records are created which are somehow interlinked - meaning if I delete one, the other goes as well.

      I have tried to determine what is 'linking' the two records together and have tried deleting all the relationships - but nothing seems to work!

      Any ideas??


        • 1. Re: Annoying - form entry creates duplicate record

          Is your "form" a portal or a layout that includes a portal?

          Simply inputting data into a FileMaker layout won't, under normal circumstances, create any new records let alone two so we need a more detailed description of what you have set up and what you are seeing that leads you to conclude that you have two new records.

          • 2. Re: Annoying - form entry creates duplicate record

            Thanks Phil, 

            It is a layout that does indeed include a portal - five actually.

            When I enter a new record, I input directly into the field 'Company_Name' that also drops down to reveal other companies on the database, which can be selected, and then proceed to fill in data on the other fields.

            When I create a new record, a blank duplicate is also created under the name of the original record, and these seem to be interlinked as deleting one deletes both.



            • 3. Re: Annoying - form entry creates duplicate record

              A "blank duplicate" in what? The row of a portal? This can be normal behavior for portals configured to add new portal records through data entry in the portal. The blank row is the "add row" that appears for adding the next new record in the portal. This row will or will not be visible in a portal depending on whether "allow creation of records via this relationship" is or is not enabled in the relationship on which that portal is based.

              But I can't tell from what you have described if this is what you see or not.

              • 4. Re: Annoying - form entry creates duplicate record

                Hi Phil,

                Thanks for that.... definitely a portal issue. All the portals are empty except for one portal that lists staff members drawn from a separate contact table. There was only one contact assigned to the company I was having problems with and there was a blank row under that entry so I will investigate the allow create/delete options in the relationship and see if that works.

                Thanks for your help!

                • 5. Re: Annoying - form entry creates duplicate record

                  Note that disabling this option changes what you can do with your portal. It may be the better option, but you will lose the ability to just start entering text into that blank "add row" as a way to add new records in the portal's table. (Many developers put a button on the layout that creates new portal records instead of this add row.)