I would like to know how to solve many - to many relationship data.
I have a client and a company table. A client can be an employee or an employer of the company. The employer can associate to more than one company. A company can have many owners or employees.
In this scenario, how do I solve this many to many relationship between these two tables.
Both of the so far have their own unique ID. In this case what I can do to solve this scenario. Does creating another table for both client and company tables make sense?
No idea to this problem.
Thank you.. hope anyone can help me with this. ...