How to make an Automatic price change

I would like for my app which sells labor, depending on the technician and the client. How can I set it up where whenever I change the technician name, it automatically generates the price “pay price” for them and the clients “bill price” is automatically generated I tried so many relationship columns and I feel like I’m just making a bunch of clutter. Can anyone help me?

Please show me a screen shot of the relevant data tables.

1 Like

Thanks for getting back to me but i figured it out al ready, thank you.