Software
and one named Suppliers
The Software
sheet has a Supplier Name
column and the Supplier
sheet has a Name
column. But there's no link between them (because it's a spreadsheet)Software
table: Supplier
Then you can make it automatically link when Supplier Name
= Supplier
Supplier Name
field in your spreadsheet with the correct value.
This makes it much easier to work with, as it introduces better filters, better views and better permissions.