2 Replies Latest reply on Jun 2, 2013 9:00 AM by philmodjunk

    New Record problems

    smokey

      Title

      New Record problems

      Post

           I've developed a music publishing program on FMP 10.  With each different client that I have I clone it and start all over with whatever information that it needs.  As I update the publishing program, I move everything over from the old one, of course. Now, here's my problem.....When I click on "New Record"  it doesn't give me a blank page, it gives me a blank title but information from a different portle.

           Can you tell me what I've done or how I can fix it?

            

           Thank you so much.

        • 1. Re: New Record problems
          schamblee

               Your databases could be corrupt.  Have you ran recover on your database?  You could just have mislinked records. If you delete records in the parent table without deleteing related records in the child table then your key fields could be crossed linked or your records could get mislinked by a design problems, such as not using serialized key fields.

               Start with a cloned databases without records and run recover on your database to check for errors.  If key fields are not serialized fields, I would update my design to use serialized key fields.

          • 2. Re: New Record problems
            philmodjunk

                 Sounds like you still have data in a related table and when you create the new record, an auto-entered serial number or other value used as a primary key is linking to data in that related table.