Link to tables (need help with formula)


Hello there!

I have been struggling for a while to connect these few dots… My base is designed to have wedding events and payroll.

When I add event, I also need that event to go in payroll. After that I need to assign musicians to each wedding/event. Every Musician needs to have a filed for different payment. Please see attached pictures. Is there a formula or any other way to create this? Please help…