I have a base that in one table has information (name, email, related projects, etc.) from every freelancer I’ve worked with. I use one record per freelancer to store their information. I want to add to each freelancer how much I’ve paid them for each project and link the project’s name to it. There are some freelancers with whom we’ve worked once, and others 10 times.
The project’s information is located in another table.
I’m also thinking that instead of adding the payment to the freelancer’s record, I can add a field to the project and tag the freelancer that worked on it, but I’m stuck on how to tag the freelancer without making it manually and not making an absurdly long table. Could I use some automation here?