I have a FM Solution lodged on a server, and am trying to develop a FM Go solution for iPhone which will have limited syncing options.
What I have done which I thought was cool, was have a table on the Deployed Solution in FM Go, which is related to an external table on the server, using a one to one relationship basedon a unique key. The idea is that when online I can sync these two tables.
Seems to be reasonably good solution but heres one little catch. In the relationship box I have ticked both delete options...you know, delete record in this table when record in other table is deleted. So when I am online, and I delete a file from the FM Go table, bam it disappears off the server table. But the opposite does not occur....delete it from the server table and it remains in the FM Go table.
Can anyone explain to me why the behaviour is not symmetrical...am I doing something wrong.