Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

How to add payment to a freelancer that has worked on multiple projects

Topic Labels: Base design
319 0
Showing results for 
Search instead for 
Did you mean: 

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?

Thank you for any insight!

0 Replies 0