AnsweredAssumed Answered

Search field in layout

Question asked by LeszekŁuczkanin on Jun 23, 2017
Latest reply on Jun 23, 2017 by mikebeargie

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?

Outcomes