I would like to have two tables each with a lookup column pointing to the other table with multiple select on and have it all stay in sync
For example - a task in the task table can have many projects assigned to it in the respective lookup column. A project in the projects table can have many tasks assigned to it in the respective lookup column. And have both many to many lookup columns stay in sync automatically.
Another example would be classes and students. A class can have many students and a student can have many classes.
Is this something you have thought about implementing? Thanks!