How to use modern lookup columns in Microsoft Lists
Lookup columns allows you to enforce a relationship between different sources of data in your data system. This feature is a simplistic version of the classic relationship between tables in a data base.
Up until recently this type of data was only available through the classic interface of SharePoint but now it’s made a debut in the modern interface of Microsoft Lists and can be used without jumping between 2 different environments.