Create related record through script
I have searched on this and found quite a bit, but cannot quite find my particular solution...
I am converting a library from flat to relational. The two tables are Library (4000 records) and Authors (0 records). Later, I will make a join table for a many-to-many relationship. But, for now, I simply need to create one entry in the Authors table for each unique author in the Library. I script will do this in seconds, but I have spent hours trying to CREATE the script.
Can someone help me get on the right page?