AnsweredAssumed Answered

Find records matching another table

Question asked by StephenBennett on Jan 15, 2015
Latest reply on Jan 15, 2015 by StephenBennett


Find records matching another table


First of all, I'm on day two of my FM experience, sorry this is probably quite basic, but after two hours of trying and searching I give up. I'm an SQL and Panorama guy, until now.

My main table contains billing records, the key field being the invoice number. My second table contains a set of invoice numbers. How do I find the records in the billing table that match the invoice numbers in the second table?

Many thanks!