Beginner question about join tables


#1

Hi!

I have the following tables set up in my base:

  • People tables - contains the name of every individual
  • Client table - contains the name of every client
  • Levels table - contains the name of every level of person and associated details for each level
  • Rates table - contains the specific $ rate of each level BY each client - so Client 1 might pay a higher rate for a VP, and Client 2 might have a lower rate for VP

My question

  • How can I create a view or join table that shows me the name of a person, the clients that person is working for, and the specific rate that person commands for each client?

#2

You need to relate records with Linked Record fields and then bring the data to the other tables with Lookup fields.