lodmark
Member
- Local time
- Today, 15:51
- Joined
- Jul 24, 2020
- Messages
- 250
Cascading combo boxes would solve my problem.
But as it works today when I only select the artists from the artist table and with a connection to record_ID sorted by release year, I get all the records that that artist has released and that I have in my collection one after the other when I scroll with the form's arrows.
I think it's pretty neat.
@Pat Hartman
I think my tables work and that with enforced RI. That is, the most important tables such as artist, record (album) and music (Song).
I know that I don't have a good grasp of genre or media, it doesn't seem to be included in all forms or is different as you point out.
This needs to be solved.
But next week I'll look at cascading combo boxes, I think.
Have a nice weekend everyone.
But as it works today when I only select the artists from the artist table and with a connection to record_ID sorted by release year, I get all the records that that artist has released and that I have in my collection one after the other when I scroll with the form's arrows.
I think it's pretty neat.
@Pat Hartman
I think my tables work and that with enforced RI. That is, the most important tables such as artist, record (album) and music (Song).
I know that I don't have a good grasp of genre or media, it doesn't seem to be included in all forms or is different as you point out.
This needs to be solved.
But next week I'll look at cascading combo boxes, I think.
Have a nice weekend everyone.
