Forgive what maybe a very simple question but I can not figure out how to create a many to many relationship between two tables.
I have two tables - Tasks and Projects. Both are many to many relationship.
Can i create a lookup column in each table or would I need to have two lookup columns to make this work. It seems when I update one lookup it does not update on the other table. How do i keep it all in sync with using lookups and many to many relationships?