I'm new with programming. I have two forms of customer registration. I have two other forms where I register some products, the quantity of products should vary more or less by 5 to 30 products at most (expectation).
They are two forms, because I use one to show the data and when I click on a button ('new' or 'edit'), opens the form with edits to register or edit. ps: The deletion does not open the registration form.
Each customer may have one or more products, usually somewhere around 5 to 10 (expectation). I have two doubts.
1st - How do I use the customer_table with the client_table? I know it has to do with primary key, foreign key, and so on. But seeing examples on the internet, I could not understand in a didactic way, I only find a lot of videoula of applications that use this. Following the lessons I can do, since I use the table structure created by the teacher, the commands of the teacher, etc. Creating my own application, I could not do this.
2nd - How do I make the products appear as Tags in the clients display form? Type these tags in email, forum, etc. For example, in my question I put the 'Delphi' tag. I would like it to appear in squares, within a field with the predetermined width, if it reaches the end, go to the bottom line and go down scrollbar (or not, depending on I do a bigger layout). That done, I believe I can apply color on them alone.
Ps: I do not use any buttons, I do almost everything with panel to stay as I want (Appearance and usability).
I've tried to detail as much as I think it's important to solve this.