I have some parent-child relationships built into my database. I also have filtered scopes based on a date field in the parent table. When the user changes the date on the parent table, I want the child records to be returned when the client
syncs.
I have looked at other forum posts, and it seems a good way to implement this is to change the SelectChanges stored procedure on the child table to also compare the timestamp with the parent table. I have implemented this.
I turn on profiling on the server and do a sync from my client. After the sync completes, the child record does not appear in the client database.
Re-running the SelectChanges command I have captured from profiling, it does indeed return the record I want. However, for whatever reason, the record does not show up in the client database.
Any help to solve this problem would be greatly appreciated.