I’m building a database for my books and I’m at a crossroads: have the library set up with genre; media type; media; and authors. Authors, genre, and type are populated and now I realize I don’t know how to get the media in.
My choices seem to be:
- Set up a sheet with the auto-generated Author_ID assigned to each ‘book’
- Start over with a hodgepodge sheet and split it into the appropriate tables in Base
- Create a macro to import each ‘book’, associated with the author
I listed the macro last because it is the most daunting/intimidating.
Any advice would be welcomed. Thanks for reading!