I have a base with a table that tracks projects. There is also a table that tracks contacts. A contact may be associated with a project, but then may be dropped or turn down the project and another contact may be associated with the project. I need to keep track of both the individuals who may be associated with a project at some point and their current status in the Projects table, and also a history of projects a contact may have been or is associated with in the Contacts table, with links in all directions. What would be the most efficient way to do this beyond having fields in the Projects table for contact_1, contact_2, etc., as well as status_1, status_2, etc.?
Thank you in advance!