Search results

Thanks @The_Doc_Man for your explanation. Of course, there is a relationship one to many and many to one. That is why you have a junction table. And my goal is to set it up as you describe it, but I'm not sure how I fill in that it is a duet or a trio and how I should present it in my forms...

Thanks @Pat Hartman I can see that. But the junction table will only hold the relations between the artist and the record. How do I with that junction table create a relation between two artists and a song (music in my database) like a duet? Or do I have to have a junction table between the...

Hi! For some time now, I have been struggling trying to create the best possibility for my database to contain duets without creating duplicate entries in the table for artists (tbl_artist). The best way to create this possibility I think is with a junction table between the song table...

So true @plog This is going to be a bit of a long story. My database is not really based on my record collection but on a list of songs I used in my radio programs. The list is based on my record collection but it was made in Excel and consists only of the name of the song, the artist's name...

Hi @MajP Today I have done exactly as you describe it. But in this way I can not see that a certain artist has done a duet, that song ends up on a record with both artists. I have a form for the artist where I in two sub forms where I can in one see which records I have with the artist and in...

Thanks for your feedback @plog . That's how I learned to do. But I did not take this into account when I created the database and now there will be problems with all questions that belong to different forms so I wanted to test if it was possible to get it in a different way. This is my database...

Hi! How do you handle this best if you want an artist table that only has unique values without duplicates? Duets such as No More Tears with Barbara Streisand and Donna Summer or Lady Marmalade with Christina Aguilera, Lil Kim, Mya and Pink. These four are listed as solo artists in the artist...

Something like that! This is the form that I'm using for the artist. It has two sub forms, the first shows the records of the artist that I have in my record collection and the second one shows the songs that I have in the database with this artist. The second one can show songs that I played...

Thanks both for your suggestions. What you suggest @mike60smart may be a great solution but as I tried to answer above, the reason I have the link to another field in the records table (record_artist_ID) is that not all songs are on records and that the song - artist link is stronger in my...

Thanks for all the input! Questions! In my artist table I have a lot of entries that holds both artists in a duett, like Olivia Newton John and John Travolta that relates to the song "You're The One That I Want". This is just one example of over a hundred others. I was manually trying to...

Not really! 76 in the list above is not the RecordID that's the artistID for the song. This specifik song is "You're The One That I Want" with Olivia Newton John (220) and John Travolta (76). The record Grease is not yet in the table/database. This is because the database that I've started with...

That's just therefore I have to get it right now! 🤯

Yes I have to do the basic work. But the artist table contains many entries that today consist of two or more artists because I added them in that way. Do I not have to first divide them into separate entries? I also do not want to destroy anything in the relationships to the other tables in...

But I think I've done that. They are keys and teh primary is autonaumber and indexed to no duplicates. I've added referential integrity between the tables artist and the middle table artist_record now. The reason that there is no referential integrity between the middle table artist_record and...

I'm sorry @MickJav Of course you are right. And it was certainly not right of me to seek help again as I did not really understand what you meant. Or, as you yourself suggest, I should think a little myself. Maybe this problem is a little too big for me. The help I got earlier from @arnelgp ...

When I started asking questions in this forum about how to create functionality in my database, I got a question about how I had intended to do with duets, ie songs with two artists. I then replied that I had intended to write the song with both artists. It now turns out to be a bad idea to do...

Thank you @MickJav I realized that I need to create this middle table. What I do not understand is how I can get the artists on the same line in my forms. I also do not see this in the picture you posted. There are no duets or other songs that have more artists than Toyah. Can you show me how...

Hi @MickJav When I started asking questions in this forum about how to create functionality in my database, I got a question about how I had intended to do with duets, ie songs with two artists. I then replied that I had intended to write the song with both artists. It now turns out to be a bad...

This is what I ordered: "Access 2019 Bible", Michael Alexander, Richard Kusleika "Access 2019 For Dummies", Laurie A Ulrich, Ken Cook "Access Solutions: Tips, Tricks and Secrets from Microsoft Access MVPS", Arvin Meyer, Douglas J Steele I have not received any of them yet but look forward to...

Thanks @NauticalGent do you have a swedish translation? 🤣 Leif