1 Reply Latest reply on Aug 8, 2011 12:56 PM by philmodjunk

    Button to Bring Up New Page To Enter Related Data

    JessicaRyles

      Title

      Button to Bring Up New Page To Enter Related Data

      Post

      I have a page/layout for entering in new organizations.  In that page I want to have a button to bring up a new page to enter specific contacts for that organization.  However I can't seem to get the two of them to relate.  They have a relationship, and in the field management I have the company_id on the second page (the one opened by the button) to look-up the number from the first contact page.  Could someone please walk me through this in baby-steps so I can see what I'm missing?  Thanks.

        • 1. Re: Button to Bring Up New Page To Enter Related Data
          philmodjunk

          Until you have values in both fields, the key field in each table, there is no link between the two records that can be used to look up the value from the first table's current record.

          You can use this script to create a new record on the second layout that's linked to the current record on the first layout. Since I don't know the names of your tables, layouts and fields, you'll have to modify this script to match what you have in your database:

          Set Variable [$ID ; value: Orgainization::ID ]
          Freeze Window
          Go To Layout [Contacts]
          New Record/Request
          Set Field [Contacts::ID ; $ID ]