What's the field type of the PIDM field?
If not text, can you try change it to text.
When we want to use matching records, we use a separate import table in FM and then importthe records in the target table.
PIDM was originally defined as Number and is a Number in the source data. I tried changing its definition in FileMaker to Text already, but that didn't make any difference.
Your suggestion on matching records using a separate import table, while not ideal, was something that has occurred to me to do if I can't make this behave properly!
3 of 3 people found this helpful
Try explicitly listing your fields in your query and change the import mapping to use "last order" instead of "matching names". Something like:
SELECT PIDM, STREET1, STREET2, CITY, STATE, ZIP, DOB FROM Addresses
Thanks, Greg! That sounds promising. I will give this a try on Monday and follow-up with the result. I appreciate your help.
1 of 1 people found this helpful
Are you using a variable for the file name? If so, try adding a second hardcoded reference to the import and see if saving the script then retains the import order and logic properly.
Thanks, Greg. Your suggestion worked.
I know this question is "answered", but why are you storing data in two places in the first place? If the data are in SQL Server, why not just access them there?
Yes, that would be an option but the source is a data warehouse that only gets updated every two weeks, so don't really need a live connection to the data. The import update is sufficient.