1 Reply Latest reply on Jun 5, 2012 9:42 AM by philmodjunk

    New Contact problem



      New Contact problem


      I am using FMPro 11.  I am using a modified starter solution "contacts".

      The database is working fine except when you select the "New Contact" button from the top menubar it adds and blank form for a new contact, however in the notes tab it adds notes from an existing record in the database.  During my troubleshooting I found that if I delete that new account and click the "New Contact" button again, it adds the notes from the next record in the database.  Any idea's?

      I want the notes field to be blank as well if I am requesting a new contact.

      Thank You, I appreciate all input.

        • 1. Re: New Contact problem

          It would appear that you imported data into your file with a contact ID, but did not update the "next serial value" setting when you did so. Thus, each new record you create is getting a contact ID that duplicates the contact ID of an existing record and thus matches to the notes records for that other contact.

          I'm guessing that you are referring to the Contact mangement starter solution here (there are many, many contact managers out there...)

          If so, put the k_ID_Contact field on your record detail layout. Select Show All Records unless it is greyed out. Then select Sort Records and sort your records by K_ID_Contact in descending order.

          Make sure you are on the first record and note the value shown in K_ID_Contact.

          Now open Manage | Database | Fields, find K_ID_Contact and double click it.

          Select the auto-enter tab in the field options dialog that has popped up and find the box named "next value".

          Change the value in this field to be at least 1 larger than the maximum value you saw in the K_ID_Contact field.