When importing files into filemaker, you can designate a "match field" and then update the record with the imported data instead of creating a new record.
I'm working on getting and putting info into Filemaker via ODBC. I can find and retrieve records just fine with ODBC (not the speediest though), but when I try to use a primary key and update a record, it simply creates a new record instead of first finding the matching record. I'd like the behavior of using the primary key as a "Match Field". Is there something I'm missing, or is it as I fear and Filemaker's ODBC implimentation is just poor in this regard.
This is using OS X, and the other side is the UPS Worldship software.
-Preston
