I have changed the setup of my recruiting database so all the players are held in one database. I have 2000 records to import into my main data table a lot of which have comments and ratings associated with them.
What I need is an import that does the following:
Checks all records to be imported against firstname, lastname, dob field
If no match, import record and place playernumber, teamname, tournament, comment and rating in first available eval fields.
If match – only import playernumber, teamname, tournament, comment and rating and place in first available eval fields
The first available eval field could be recognized by looking at the Eval1comment and the eval2comment field until it finds the first one with no text in it and then import into that eval set.