Hello, is it possible to get the nth matching record from the front end?
I have a table of client details. One of the fields comes from a table with multiple client records as more than one instance can apply to any one client. I do not want duplicate records of clients in my table (which I obviously get when I bring this field into my table). Instead, I would like to show the different iterations of this field sequentially by column (maximum of 4). How do I bring in the nth matching record (up to 4) for each column?
Thanks in advance.