M
Miikka Hamalainen
Hi there,
I have problems with forms and tables.
I keep getting "duplicate values not allowed"-error message. And I know why
I have created form from two tables; artist and song
I have linked the tables with artist_id field
What I would like to do is to add new artist to db straight when adding new
song.
For example:
I have created artist Queen(artist_id = 1 ) and would like to add song to
db.
I have form with fields:
artist_name
song_id
song_name
Is it possible to just write "Queen" to artist_name field and access then
would link this song to artist Queen (artist_id =1)?
Or do I have to write some code to check if this artist exists in db or not?
I would like to avoid using ids when adding new songs. I don't want to read
the artist numbers from another sheet, when adding new songs.
Br, Miikka
I have problems with forms and tables.
I keep getting "duplicate values not allowed"-error message. And I know why
I have created form from two tables; artist and song
I have linked the tables with artist_id field
What I would like to do is to add new artist to db straight when adding new
song.
For example:
I have created artist Queen(artist_id = 1 ) and would like to add song to
db.
I have form with fields:
artist_name
song_id
song_name
Is it possible to just write "Queen" to artist_name field and access then
would link this song to artist Queen (artist_id =1)?
Or do I have to write some code to check if this artist exists in db or not?
I would like to avoid using ids when adding new songs. I don't want to read
the artist numbers from another sheet, when adding new songs.
Br, Miikka