henrik_ahlgren Posted February 27, 2002 Posted February 27, 2002 Can someone please explain what I do wrong! I have a FM Pro 5 database with six fields. I import data from Excellsheets and there can be doubles in them. My thought was to use the option "Update matching records and add new records" in the FM Importfunction and set the match one three fields which should capture the doubles and update the record if the three fields alla matched and then add all the rest. But this doesn
henrik_ahlgren Posted February 28, 2002 Author Posted February 28, 2002 My thought is that a matching record constitutes of exactly the same contents in all the three fields I put as matching criterias and then three other fields. If there is a match the record is updated and not added to the records, but if there isn
Fitch Posted February 28, 2002 Posted February 28, 2002 It would help to know what you mean by, "But this doesn
henrik_ahlgren Posted February 28, 2002 Author Posted February 28, 2002 It works! I think it was a the testtime field that was the problem, maybe because of ane extra space after or something that I couldn
Recommended Posts
This topic is 8305 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now