Forum Discussion
2 Replies
Sort By
- SuryaExpertQrew Assistant CaptainI am assuming the "PO Number" is the primary key on the table you are importing into. As long as that is true, you can import from the files one after the other. Quick Base will automatically merge the data from the two csv files.
- ChrisSwirtzQrew CadetNo see i figured that would be the way to go but for some reason it isn't merging the info, just creating new records for the info from the 2nd file. I must be doing something wrong. When uploading the 2nd file of data, i select to use the "PO Number" as the existing field for the PO Number field on the 2nd file and then leave the rest to create new fields. I thought it would then go look for that PO# in the existing records and add the new info to the corresponding record. Is it because there are multiple existing records with the same PO Number? Or am I just doing it totally wrong?