Sounds like you need a joined list
Have a watch of the below - I suspect it will get you on the right track…