creating new customer ID's in an imported Bento Database
I have Bento 4 and FileMaker Pro 13. We were using Bento to link two databases, customers and donors. Now we are updating to Filemaker Pro 13 but to link the customer contact and donor tables we need a distinct customer ID to link the two tables. Unfortunately our Bento table did not include a customer ID field. Is there a way I can get filemaker to attach incremented customer ID's to each record imported from Bento?
We have several thousand customers it would be great if filemaker could generate the ID's automatically.
Thanks for any assistance.