Hello.
I'm pretty new MS Access, but I need this quickly.
I have a table with 3 columns: bands, main genres and music styles.
Main Genres and Music Styles are both Lookup and Relationship fields.
Main Genres is connected to a Main Genres table with about 10 records, and Music Styles is connected to a 2000 records Music Styles table, where for each Music Style there are one or two main genres connected to Main Genres table.
What I would need is that if I choose in the Bands table the main genres (multiple option), in the Music Style column on the same row I should only be able to choose from the Music Styles related with the Main Genres I chose.
I would apreciate any help. Ask me if something is unclear.
Thank you.
I'm pretty new MS Access, but I need this quickly.
I have a table with 3 columns: bands, main genres and music styles.
Main Genres and Music Styles are both Lookup and Relationship fields.
Main Genres is connected to a Main Genres table with about 10 records, and Music Styles is connected to a 2000 records Music Styles table, where for each Music Style there are one or two main genres connected to Main Genres table.
What I would need is that if I choose in the Bands table the main genres (multiple option), in the Music Style column on the same row I should only be able to choose from the Music Styles related with the Main Genres I chose.
I would apreciate any help. Ask me if something is unclear.
Thank you.
Last edited: