1 Reply Latest reply on Mar 1, 2012 4:09 PM by Malcolm

    Linking tables?

    maxwelljcoleman@me.com

      My database has a table for demographic data and a table for billing data. The first field in the record of each table contains the unique identifying number of the client. How can I ensure that when I enter the last field in the demographics field and hit tab or enter it will take me to the nominated files in the billing table? THE DATABASE IS IN FM PRO11 (Mac)

        • 1. Re: Linking tables?
          Malcolm

          My database has a table for demographic data and a table for billing data. The first field in the record of each table contains the unique identifying number of the client. How can I ensure that when I enter the last field in the demographics field and hit tab or enter it will take me to the nominated files in the billing table? THE DATABASE IS IN FM PRO11 (Mac)

           

           

          1. Create a script which uses Go To Related Record (GTRR)

          2. Add a script trigger to the field that will run the GTRR script on exit

           

          Malcolm