Hello everyone!
I've 1 table with the name Salesman
(Fields: code_sales, Lastname, Username, Department, Phone number etc)
and a 2nd table with the name Products.
(Fields: code_product, Name of the product , From which country , date etc)
Each table have some properties like , specific characteristics with numbers , date, subnet mask etc.
The task "tells" me that i've to create a 3rd table with the name Sales. The table Sales will accept from the table Salesman the code_sales and from the table Products will accept the code_product, there are also some fields.
Can this happen simltaneously in the table Sales? and how?
I am thinking that a potential solution might be like this:
tblsalesman relation to tblsales (one to many)
tblproducts relation to tblsales (one to many)
the primary keys are in the first table the code_sales and in the seconde table the code_product, so in the third tblsales i will enter the the code_sales and code_product (numbers).