lodmark
Member
- Local time
- Today, 14:14
- Joined
- Jul 24, 2020
- Messages
- 232
Hey!
As you can see, I'm new to the forum and have not yet read through everything in here. I also suspect that my question may be due to a misconception when I created the database.
I have created a database in Access (of course) that handles my vinyl record collection. I searched for a long time for a template online but without being able to find what I was looking for. So I decided to create it myself. I have some "old" knowledge about Access.
The basis of the database is an Excel list where I collected songs that I played in my radio programs. So my main table is a list of songs from my records without connection to a specific record, only to the artist. Today it contains about 1600 entries.
I have created a table for these songs, a table for the artists and a table for the records.
Since a song can appear on several discs, there is a many to many relationship here. Therefore, I have also created a table for this, it is between songs and records in the relationship.
My problem is the form that should add new records or update ones that are already in the record table. The form is based on the record table with a subform based on the table that handles the many to many relationship. This is the table I want to update or add new songs to the records.
The subform contains a combo box with a selection from the song table so that I can select songs for the records that are already in the table.
But I also want to be able to enter new songs if these are not in the table for songs via this subform.
Now to my question.
Each time I select a song from the combo box, a new entry is created in the song table. I only want this to happen if I enter a song that is not in the table already.
I hope my description of the problem can give you an idea of my dilemma.
I will try to post my database here soon. If This will help.
Grateful for all the help are:
Leif
As you can see, I'm new to the forum and have not yet read through everything in here. I also suspect that my question may be due to a misconception when I created the database.
I have created a database in Access (of course) that handles my vinyl record collection. I searched for a long time for a template online but without being able to find what I was looking for. So I decided to create it myself. I have some "old" knowledge about Access.
The basis of the database is an Excel list where I collected songs that I played in my radio programs. So my main table is a list of songs from my records without connection to a specific record, only to the artist. Today it contains about 1600 entries.
I have created a table for these songs, a table for the artists and a table for the records.
Since a song can appear on several discs, there is a many to many relationship here. Therefore, I have also created a table for this, it is between songs and records in the relationship.
My problem is the form that should add new records or update ones that are already in the record table. The form is based on the record table with a subform based on the table that handles the many to many relationship. This is the table I want to update or add new songs to the records.
The subform contains a combo box with a selection from the song table so that I can select songs for the records that are already in the table.
But I also want to be able to enter new songs if these are not in the table for songs via this subform.
Now to my question.
Each time I select a song from the combo box, a new entry is created in the song table. I only want this to happen if I enter a song that is not in the table already.
I hope my description of the problem can give you an idea of my dilemma.
I will try to post my database here soon. If This will help.
Grateful for all the help are:
Leif