FMP/ODBC Record commit question
Apologies for what is probably a very basic question, but I can't find a clear answer.
Using FMP 10 connected to Sequel Server tables, I notice that -- although I am able to edit info in a SQL field and (apparently) commit the change in FMP -- the change does not appear to be pushed to the tables themselves unless or until the FMP file is closed and reopened.
What's happening (or rather, not happening)?
[Mac OS 10.6.2, ODBC drivers up-to-date, SQL Server permissions apparently OK....]