I have a download only sync table called tblCustomers for which the PK is integer. I have an application that allows users to insert data into tblCustomers. Since it is download only, i have to wait for the sync to dowload the changes to my CE store. But
i need the data immediately in the UI to be able to edit and process further. How can i achieve it ?
Design restriction is that i cannot change the syncdirection for the table. I tried to insert the record using the PK that gets saved in the central store but the data gets duplicated in the local CE store and the next time i query, i get duplicates.
Any help is appreciated.