Despite there is a ton of “percentage topics” i cant figure it out. Basically i have my tables automated with zapier and they work well, but i want to add 2 things and i just cant (because my bad english i cant realize how is Airtable working)

Basically I have several tables where a house repairing services data are going to be stored.

• 
  

  I have a “Client” table (in here we put al the client data and budget, this records are auto-filled.
  
  (It would be amazing to add an “Auto-ID record” for future tracking tables! Lets say “Work #1” or just “#1” or “1”)

  
  


• 
  

  I have another table for my employees, where they can login and see new projects and projects where they are working on

  
  

Basically, i want to show in the “Employees” table the 80% of the “Budget cell” that is in the “Client” table (if budget is $1000, they win $800 so i want they see only $800), if can be done, how about making another table called “Company Net winnings” where i need put the remaining 20% of the budget for tracking incomes?

An example is (commas mean cells):

Table Client

Jhon Cena, 3rd Avenue, Painting, Visited April 22, $1000 (if you can tell me how to auto-add an record ID would be amazing)

Table Employee

Mark Painter, Painting of Work number #1 (John Cena’s record ID! :grinning_face_with_big_eyes: ), profit is $ <80% of the budget>

Table Company Net winnings

In here i would like to have "Work #1 (again, the John Cena’s record ID), profit is $ <20% of the budget>