Help with database tinkering
I have a database with several many to many relationships. My database gets new records inputted every day. Whenever I tinker with my database, I make a copy and work with that. When I get it where I like it, I want to be able to import the records that have since been inputted into the original file. I understand I can import from file and import the new records. The problem is that not all the related records seem to get imported. I have been able to import the related records somewhat successfully by switching to that table and doing the import again, but this is tedious. Is there a more efficient way of doing this?