I have a road network layer that has a unique id "ID_2" for each road segment. I also have a table that contains the route for each bus network. Each row in this table contains the name of the bus and the road that the bus travels in the form of "ID_2".
I want to join these two in such a way that my road network layer must contain all the bus route numbers for each road segment.
Is there a way to do this in QGIS?
Edit: I have tried the following procedure already
Using relations: With parent as my road network layer and child as my bus route table and ID_2 as the relation. But I don't see it when I select the road network layer information.
Using join: This gives me only one route number for every road segment while actually each road segment could cater to multiple routes.