I have records like this
In above record you see that top 4 records assume that these 4 policies are not in previous year i.e. 2017 so this is new business .
5th and 6th records their policy no are not found in records nor in previous and not in next year this is lost business
and last 2 records p no 122 then again in next record is 122-1 this is renewed business
so from here i want to find out when P no did not found again in records then consider this lost business so i want when i click on that records then message should displayed "LOST"
this is link of folder
https://www.dropbox.com/sh/q56i4biyt8t03ow/AACfXuu5qx_5Vad0Au-YuRlia?dl=0
