Good afternoon,
Please see attached db I'm trying to check for duplicated record of tblRed based on selected loc name, but apparently it is not working as I want to be, as it is returning all the records of the selected loc name as duplicated records, it seems that it is making the comparison across the whole VSN of other loc as well.
Thanks in advance
Please see attached db I'm trying to check for duplicated record of tblRed based on selected loc name, but apparently it is not working as I want to be, as it is returning all the records of the selected loc name as duplicated records, it seems that it is making the comparison across the whole VSN of other loc as well.
Thanks in advance
