I have created a database of movies, each with thumbnails, cast, some notes, etc. Now I want to add 50 more titles to the database. The new set is just a list of titles.
If I view the original database as a list, and paste the new titles in at the bottom, it seems to break all the existing records; ie the titles are no longer associated with the correct records.
I tried doing the ‘Merge databases’ approach: I cloned the existing database and deleted all the records, thus creating an empty database with fields that are identical to the original database. Then I imported my new titles into this empty database, figuring it would create new records for each title, with each new record containing appropriate fields ready to be filled in. But that doesn’t happen. Not sure what happened to the ‘template’ of fields from the original database, but it’s clear that my newly imported records (my list of movies) did not inherit the fields from the cloned database into which they were placed.
How should i approach this?