Hello Ramon, Thank You for replying. I checked on my links. My table is connected to three other tables using 0 and 1 cardinality simple link.I understand that Count basically just executes a count on the table itself while view fetches the records including links/joins to other resources but when I try to access my table from navigation client data>> products, I can visibly see my duplicate records.Also to explain more, I tried two things:I try to search (say ID 123456) in ACS>>client data>> pr...