I've been learning mysql for a couple weeks because I need to make a JAVA program where I can add clients to a table(JTable).
The structure on mysql to do that is quite simple, just make a table with name, phone, address, etc.
The thing is.. those clients buy products, and I need to put that on the mysql aswell. So imagine I have clients, and each client buy things right?
How do I manage that? I've been thinking on an idea but I don't know if it is the best one:
-each client has an unique ID, when I add on the products table, I just grab the ID from the client and put it on the product.. So if the client ID.1 buys 5 products, I would have on porduct table:

* id - 1 ; product - shampoo
* id - 1 ; product - computer
* id - 1 ; product - trashcan

and when I want to put on a table(JTable) I just grab the products by the ID, but is it really a good way of doing it? 

I hope you understand my question, what I need and want, and thank you for your time in helping me!
Also sorry if I made any english mistake.

**EDIT:** My idea is a two tables mysql structure, the rest it's explained

**EDIT2:** I'm sorry I should have explained better, the thing is, the "product" can't be initiated, it will be created at the time. Imagine you have an entreprise which do a little bit of everything such as: Sell a home, build a home, build a kitchen, sell yogurts, (an entreprise which find clients to your client and earn a % money, a comission I would say). SO there is no way I could know what our client want us to do.