Best Approach for Implementing Many-to-Many Relationship in Bubble

Totally agree with given answers already. Also I would suggest checking out this post which compares between all the different options.

Hope this helps !