Script that creates new records
My library db has a table Books (1100 records) that contains all the fields I'm using. A big mistake from the start. One of these fields is Authors. I now want to create a table Authors and new records for all the authors. I know it's doable by script. I searched this forum quite extensively and found one post where the situation described is almost identical to mine. Create related record through script But it is not completely identical because some of my books have more than one author, and the script suggested by PhilModJunk assumes that there is only one author per book. I have no clue how to tweak that script so that it would work for me. Help would be greatly apprreciated.