G
Guest
I have made 1 to many relationship.. but I still don't get the use of that. I
don't know how to make use of it.
I made a customers table which include a field "customerID" as a primary key
and other info fields about the customer like address, state...etc
The second table is about sales. It has a field "SalesID" as a primary key,
and a field called "saledate". I added the field "costemID" in order to make
a relationship 1:many between the first and the second table.
The third table is about items. It has a field called "ItemID" as a primary
key and "ItemName" field
I added a field to Sales table which is "Item ID" in order to make 1:many
relationship between the second and third table.
this is was an exercise in a book. but it stops here. I don't know what's
after that. how to practically use these tables and relations
can any one please help me?
don't know how to make use of it.
I made a customers table which include a field "customerID" as a primary key
and other info fields about the customer like address, state...etc
The second table is about sales. It has a field "SalesID" as a primary key,
and a field called "saledate". I added the field "costemID" in order to make
a relationship 1:many between the first and the second table.
The third table is about items. It has a field called "ItemID" as a primary
key and "ItemName" field
I added a field to Sales table which is "Item ID" in order to make 1:many
relationship between the second and third table.
this is was an exercise in a book. but it stops here. I don't know what's
after that. how to practically use these tables and relations
can any one please help me?