Search results

Thanks @arnoldg. Now it works to add titles from the combo box to new vinyl records. But if the title is not in tbl_music, I want to be able to enter it in the combo box and that it is then saved in tbl_music at the same time as it is added to the vinyl record in the table tbl_music_record. If...

Sorry, I saw that the order was in the form now. It looks exactly what I want, wondering what wrong I did? Leif

Thanks, @arnelgp I will try to remember to zip it in the future. Yes it works as I intended but I lack the order of the songs on the record. Could it be that it became a hassle because the field with the order was in the table that was the middle table in many to many realtions between the...

Here comes the latest version. As I said, I managed to create the form to create records for records (funny). But it is not finished, still can not save in the subform. Leif

I succeded in creating the form and proceding with the databse. Hold on downloading the one thats in this tread. A new one is coming. All in english.

(y):)

Forgot to tag you. @isladogs and @bob fitz

I decided not to give up so easily with you. You wanted me to start over, so I deleted all the forms and questions in the old database. Then I renamed all the names of tables and fields to English. I then created a form for artists and their music. What I want help with is of course if the...

Thank you guys! I think about what you recomend. Still I think there's something wrong about how I set it up. Have a wonderful life! Leif

I'm still interesting in how you could get the ringt ID for the song @bobfitz.

Thanks for Trying Bob! The ID_Key is from the creation of the table, I've later change it after @isladogs suggested it to get a unique primary key combined by two fields.

I've downloaded my own database from this thread and tried to do what you've done Bob. And this is what I get.

YES! Thats the right ID for Skyfall in the table t_Låtar. But i don't get that number when I try. What form are you using? f_Skiva1? And are you trying to write in a new record from Adele with the song Skyfall on the first side?

I'm so sorry to hear this @isladogs. Glad though that my app isn't the problem. It works fine fore me in general. Hope it will work out allright for you, and that I'll here from you soon again. Is there anyone else who will look at my problem? Leif

(y)

New database without attachments. Try to do this. 1. Open the form "f_skiva1" 2. Click on new entry in the main form 3. Click on the arrow to the right in the field "t_Artist/Grupp_namn" 4. Select an artist and fill in the rest of the fields in the main form as you like 5. You can now click in...

Sorry! Couldn't sleep whitout trying out your tip. Changing to Inner Join didn't make the table not trying to create new record. Just saying! Good night from Sweden. Leif

Thanks! I'll get on to this tomorrow afternoon. Now it's time for bed. We'll talk again soon. Leif

Coming here! I've deleted the entry with Stevie in t_låtar. Thanks for trying to help me, I still think there is a slight misconception when I created the database. Leif

Hi isladogs I have now read the first part of your article. It gave me a clue I had ignored before. I have not had "Delete records in related tables" checked. So it's done now on all relationships. In the picture "Records relations" you see what my database looks like today. I've done some...