Cross linking data across tables

[nirmala_shome]

I have three data tables that I want to connect in my layouts:

• Games that have Genres and Subgenres
• Genres list that I want people to see under each Genre the subgenres and the games that are that genre
• Simllarly a layout for Subgenre that will show under each Subgenre the Genre it’s apart of and the games of the subgenre

I want all these to connect and link across each of the layouts.

Do I need to create two look up columsn for each data table so that it cross references?

[jb_1mprove]

Hey @nirmala_shome what you’re looking for, is creating a relation between the tables. Check out this video: https://m.youtube.com/watch?v=-7uTpgNh5h4

Without creating the relation, you won’t get relevant results with a lookup column. Once you’ve created the relation, you can “lookup” the “linked” data through that relation. Hope it makes sense. Otherwise, just reply here. But first check out the video;).

[nirmala_shome]

Thanks this worked!