AnsweredAssumed Answered

Value List into separate records

Question asked by jimbo123 on May 12, 2017
Latest reply on May 12, 2017 by beverly

I'm getting there as a newbie, but for some reason I can't work this one out:-

 

My first post after a cranial removal op ! so please excuse the methods.

 

I have a table where we download one table that shows transaction records (a bank account) with the usual fields:- date, amount, description etc which also has the field "Account #"

I need to make a separate unique list (portal/table) of the "Account #" references only eg, 12345-6789, 12345-9876 and so on to enable more filtering. I have a drop down list for searching the field "Account #" and everything else works fine, but I can't find a way to extract the unique "account #" values from the value list and display separate totals for the different account numbers (in a new layout/portal/tab).

 

 

 

 

FM 15 pro Advanced

 

Outcomes