Hello everybody. I am quite new to Access so I will do my best to explain as clearly as I can what I am trying to do.
I have a database that handles a collection of music. Simplified, let's just say the database has 3 tables:
Album(+albumName)
Genre(+genreType)
AlbumIsGenre(+album, +genre)
AlbumIsGenre is the table that handles the "many-to-one" relationship between Album and Genre (there are many albums, each has one genre).
I am trying to make a form that will allow me to view albums and their associated genre and add a new album. Currently, my form uses the AlbumIsGenre table (only) to display album names and genres. This works fine, I can view them all.
When I try to add a record however I get: "You can not add or change a record because a related record is required in table 'Album'."
I understand why this is happening and it is expected behavior. But how can I tell my form the add the new record albumName to Album before creating the new record in AlbumIsGenre?
Thank you for your time guys, help is greatly appreciated, need to hand in two forms for Monday!
PS: This is what we call "cascading" no? Not sure if I got the term right.
I have a database that handles a collection of music. Simplified, let's just say the database has 3 tables:
Album(+albumName)
Genre(+genreType)
AlbumIsGenre(+album, +genre)
AlbumIsGenre is the table that handles the "many-to-one" relationship between Album and Genre (there are many albums, each has one genre).
I am trying to make a form that will allow me to view albums and their associated genre and add a new album. Currently, my form uses the AlbumIsGenre table (only) to display album names and genres. This works fine, I can view them all.
When I try to add a record however I get: "You can not add or change a record because a related record is required in table 'Album'."
I understand why this is happening and it is expected behavior. But how can I tell my form the add the new record albumName to Album before creating the new record in AlbumIsGenre?
Thank you for your time guys, help is greatly appreciated, need to hand in two forms for Monday!
PS: This is what we call "cascading" no? Not sure if I got the term right.