Number
, Floor
, Extension
, Desks
, Image
Name
, Number
, Email
, Image
Name
, SKU
, Image
, Price
, Description
Room
has a Floor
?Team member
has a Manager
? Or an Office
? Product
has a Category
?Staff
have Locations
. Talks
have Speakers
Articles
have Authors
.Location
lists all the Team members
that work there Manager
, they have a list of all the Team members
they manageStaff
table and a Locations
table.Staff
to the Locations
they work in. This will allow us to do several things, including links to their Location
on their profile.Staff
table, we can make sure thereโs a column for the name of the Staff
โs Location
. And of course, in the Locations
table, we already have a Name
column with the name of that Location
.Staff
to Locations
we will:Location
column (in the Staff
Table) matches the value in the Name
column (in the Locations
table).Locations
table has been brought back. Now we can display and use that Relation in various ways.Staff
that work at a particular Location
, we will need a Multiple Relation because there is likely to be more than one in every Location
.Locations
table, create a new Relation Column, and match items where the value in the Name
column matches the value in the Location
column in the Staff
table.Location
, but if we click โMatch Multiple,โ the Relation brings back all of them.