Search results

OP? :unsure: 🎅

Am I right @MickJav if I interpret your picture above as that you must have both Kylie, Jason and Kylie and Jason as three unique items in the table for artists? Leif

The picture shows the form for all a group's recordings and if I understand you correctly, it would have been shown in the box for "Artist Types" if the group was a duo or similar. What I want to achieve is that for a compilation album that contains a song sung by two artists, both artist names...

Maybe I'm asking really stupid questions but what's an "ERD"? I have created an account on your website @MickJav to be able to download the database called "Disc Jocky Bookings And Music Library" but it is a .drawio file that I can not open. I would be grateful if there is an opportunity to see...

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...