ODBC Confusion, getting data from MS Access table, import to FMP10 table.
ODBC Confusion. I have an MS Access DB containing test results from a test set (DB came with Test set). I want my filemaker program to find a related serial number and bring over the latest test date. I have a script run import that almost works fine! it imports the second latest date from the table. The table is sorted by date, but for some reason it wont get the most recent one, just the one before. I have tried everything i can think of. my odbc connectivity in windows is set with an access driver and I can find the table ok to create the data source and sql statement(incl sort) but still only get the second latest one. I don't have much hair left, can anyone help me please.