I'm a bit stuck on this issue and wonder if you could help? we have field workers who do not have access to the companies Servers and need to be able to download data from the live SQL Server datbases and work with the data offline on their tablets and then update the live database again at the end of the day. If is not possible for them to be logged on at all times due to issues with site locations etc. I would like to be able to trap any records that get changed during the day, probably on only a handful of specific tables and then to be able to run an update query to push the data back into the live system when they log back on. I'm imagining something that would know when a form has been updated and which field in an underlying table has been changed. I think I would then record that change to a table which would hold the name of the table and field to update along with the value to change. I'm stuck on knowing how to identify the control that has been updated.
Any help as always would be very much appreciated