Importing records problem
I'm not sure how to get this working in Filemaker Pro 9, but here is what I am trying to accomplish.
Database 1: Group Table. Has groupID as the primary key and a field to store an agentID. Names, etc.
Database 2: Agent Table. Has agentID as the primary key. Names, etc.
I'm trying to get the agentID to import into Database 1 where the names match. I can export the names from both databases and then match the groupID with the agentID in excel and import that back in, but even still it only asks me to update/replace data. I wiped all the data in Database 1 on my first attemp. Luckily I backed it up!