I would like to create a relational database in which there are two tables Users and products. Each item of each table can be related to many items of the second table.

My current implementation is as follows:

Two main tables-

```
->Users
User ID
UserInfo

->Products
Product ID 
ProductInfo

```

Two different lookuptables

```
->UserToProduct
UserID
ProductID

->ProductToUSer
ProductID 
UserID

```

Each time a relation from a user to a product is added, i just add an extra row to the first lookup table, and vice versa.

Is this the right way to do it? Are there any standard models for such scenarios that I can refer to?