Search results

Yes, yes, yes. It's an older version. This is the version I got help with about a year ago. I posted it because I wanted you to see what it looked like before I started adding what was suggested in this forum. My problem in this version was just adding tracks performed by more than one artist...

You're so quick. I'm amazed. Thanks @MajP Haven't had the time to look in to this yet, the time in Sweden is 7:30 PM and I think it would be the night shift for this. I'm so curious. This is the file containing my working database. Look at the difference between the relationship schemes, then...

Nice! Thanks, swedish? Yes, for now there's only these two. I'm hoping to be able to add tracks directly with two or more artists on. When I search for the song I get the tracks doubled? I downloaded your file. Same result. Leif

Perfect! Some issues is yet to overcome, eg. how I can add tracks to a new record as artist or as various. But this is one step forward. Many Thanks! Leif

Result #Name? But definitly quicker. If I try to run your query in the function below it says: Syntax Error If I run this query: Select * from qry_Concatenate where Music_ID = music_ID; I get a result, but it still says #Name? in the form. I can add the working database later if you want. As I...

Hi @MajP I will soon post the file/files. But I've tried to put the concate function in the field for artist in the subform (frm_record2_subform). When I first tried the function the only way for me to get the function to work is when the argument (eg. the ID-fields) are taken from the same...

I'll post it when I've sorted out all my bad examples. For now I'm not shure what I've done. :oops: Leif

This is a interresting way forward, I will try this in some way. Thanks everyone! Leif

I'm trying to put the concat function i the filed for artist in the subform. So far the result is only "#Name?". I've tied this to but then I Only get the limited group as the result and then I can't view all my records. Leif

This example is from the film where The Bee Gees was the main artist, and many others performed. The Beatles record wouldn't show you what I mean. It's bound to a query. Query1. But I agree with everything else that you say. I'm trying to put the concat function in the subform but at this...

Hi @Minty Of course, The Bee Gees & Paul Nicholas is not one artist. This is what I want to be able to present in a good way. This is what happened when I added the song because I did not have an alternative then. Everyone who has helped me wants the same thing, but I probably do not...

Hi @Pat Hartman This is what it looks like when I look at a vinyl record in my record collection in the database. This is the soundtrack to Sgt. Peppers where the Bee Gees did many songs together with other artists. The first song with Bee Gees and Paul Nicholas is a new entry in the artist's...

Did not think so far, it was wise. It is already done. I will keep that in mind. Sheet music will probably never be a subject that I will work with because I am not a musician but "just" a DJ. There are songs in my record collection, e.g. 7 "and 12" where the songs have different lengths...

Hi Pat, I'm glad you still want to answer me. I have the greatest respect for your knowledge and experience. I agree that much of the job is to plan how the different parts of the database should be connected and in that case I have failed. But maybe you can save some of what is already stored...

I understand and have now removed that relationship. Unfortunately, it is the case that some of the songs I play in my programs are not available as records in my record collection but are taken from Spotify and in some cases from Youtube. So the relationship with a record is not self-evident...

Sorry but the headache is still here. :LOL: You sad that - "Your separation of "music" from "record" makes no sense to me." I understand that it was a mistake to name the table containing the tracks on the records for tbl_music. And it was also a mistake to write song instead of tracks in my...

Sorry to hear that @Pat Hartman But still, with my new explanation of what the tables contain, I would like to see how you would make a correct schedule. Maybe that would make me see my mistakes more clearly. After that, maybe I can move on with my basic problem. Leif

Thanks for your reply @Pat Hartman 🙏 First of all, I would like to apologize again for the names on my tables are so misleading. Now take this in the right way, when it comes to vinyl records I know what I am doing. @Pat Hartman as you write in your first comment you seem to have misunderstood...

I have tried to create junction tables myself between the tables that had a connection to ID fields. I then deleted these ID fields, record_artist_ID, music_artist_ID and music_artist2_ID. It created some errors in the forms but these I am trying to fix. Just hope I can save new records. I...

Thank you for all your input. And thank you @Pat Hartman You are quite right in pointing out that you gave me the solution already last year. But either I did not understand it or it meant too great a change in what I, with your fantastic help, have already achieved. I may have been stuck in...