AnsweredAssumed Answered

How can I pull all the data from one column in a table view?

Question asked by beastblittle2 on Nov 7, 2018
Latest reply on Nov 7, 2018 by sccardais

Hi All,

Let me preface this by saying this is my first post, so if I'm breaking any rules or causing any problems, please let me know.

 

Right now, I'm tasked with updating our current FileMaker system (which was made by someone else a while ago, the "Classic" theme is still in most of our files). What I need to do is pull what the different Store Codes are for one customer, Customer 1532 here, and list them out. For example, the output I'd like is something like "I30, SK93, HV86" with no repeats in a field. However, whatever way I try pulling the Store Code, I only get one, the most recent, being HV86.

 

 

How do I accomplish this? My understanding of FileMaker is pretty mediocre, so forgive me if it's an obvious solution. I'm currently running FileMaker Pro 16.

 

 

Thanks,

Andrew V.

Outcomes