Many to many: Entering data in forms for many to many relationship displayed in form

[Myriam Kwek]

Hello everyone,

I've built a database with many-to-many relationships which is basically the same as the one in the link, but instead of artists having albums with genres, components have failure modes with genres.

http://www.databasedev.co.uk/many_to_many_example.html

I'm referring to the form "View albums by artist".

What I need in the form is:
Artist ID
Artist Name

Then, instead of a dropdown box which allows me to select the album ID, I need a dropdown box which allows me to select the Genre of the album. Having selected the Genre, all of the albums associated with the artist of that genre should appear.

For example:

Artist ID 1
Artist Name U2

Genre "Rock" is selected.

Album ID, Album Name automatically appear:

3 Heathen Chemistry
7 The Joshua Tree

with a box next to them which allows additional information to be entered for that entry by the user (for example, a comment about any additional details necessary).

Thanks a lot.

[ADezii]

Just subscribing for now, will return later.

[Myriam Kwek]

Thanks, see you later.

[ADezii]

To demonstrate how do all that you have requested would be a little time consuming, to say the least. What I did to help you along is to Download the Demo and make some modifications to it. On the View Albums by Artist Form, I placed a Select Genre Combo Box in the Upper Right Corner. Selecting a Genre will now Open a New Form displaying all of the Albums associated with the Current Artist displayed on the Form, for the chosen Genre. This, hopefully, will at least point you in the right direction. Download the Attachment and judge for yourself. Good Luck.

[Myriam Kwek]

Hello again. I just tried your example and it works. However, it's not exactly what I need. I have 2 Linking tables in the database: tblLink_Artist_Album and tblLink_Album_Genre which I added. (many to many).

When I select the Genre for a specific Artist, the Albums of that genre for that Artist should appear, WITHOUT having to enter that data into the form previously (the Artist-Album demo does require that you input the albums associated with each artist previously). I've tried to do it, without success. Thanks and regards.