Linking / Creating multiple Lists

Hi just started using this program but running into some problems with links and databases. Not sure how to go about it. I have a main list of products eg. <Car tyres/windows etc.> and want to make a link that when you click a category in that list it will load eg to load a list of brands or model for tyres as an example. When i try to add a second list say it will only load my first list that i made. What am i doing wrong or is there no way to do this?

Hello, i sent you a message