1 Reply Latest reply on Jun 23, 2017 5:24 AM by mikebeargie

    Search field in layout

    LeszekŁuczkanin

      Hello,

       

      I have two tables

      OPERATIONS

      operationsID pk

      date

      year [calculation field: year (date)]

      amount

      description

      invoice number

      account ID fk

       

      ACCOUNTS

      accountID pk

      account name

       

      Tables are related

      account ID fk >--- account ID pk

       

      I have a report based on OPERATIONS grouped and sorted like this:

      year

      accounts::account name

      invoice number

      date; description, amount

       

      I want to filter all records by account name.

      In my report I used merge fields. I put only a field accounts::account name in the header of my layout but using find or quicksand doesn't work.

       

      I try making a script but it also doesn't work.

       

      Any ideas?

        • 1. Re: Search field in layout
          mikebeargie

          Sounds like your relationship is invalid in some way to me. A find in account name should find for your queried account if properly related.

           

          Make sure that:

          1) FK and PK keys are the same field type (EG text with UUID, or number with auto-enter serial).

          2) Properly related in the relationship graph

          3) Data is filled in appropriately with matching FK and PK keys.

           

          On your accounts table layout, if you make a portal to operations, can you see those related records?