Beginner question about join tables

[Neil_Barman]

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?

[Elias_Gomez_Sai]

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