Hi guys,
I'm sort of new to MS Access, but as a student I have a project that I'm due to complete to Monday. So I would need your help!
My theme is "CD shop" and there are 2 tables that I'm trying to make a form out of. They are related many-to-many and therefore have a 3rd, relational table.
1st table is: Artists
2nd table is: Albums
Since one artist can have multiple albums and vice versa, I've created a 3rd table: Artists_Albums with the IDs of both tables, and made both those IDs a primary key in the table.
Now... I want to create a form which will be called "Enter new Album", and it should allow the user to enter a new album into the database, without first entering the artist info, then the album info, and then connect those two through the relational table...
I want to make a form that allows to do all that in one step. A user should enter the name of the album and the artist for that album, and those 2 should then be connected in a database.
Please help me solve this problem!
Kind Regards,
Zannix