Relationships - help me please

[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?

 

[Guest]

You would build queries that had these tables. Then forms and subforms that
used the queries.
The form would show the customer and their information. The subform would
be Master/Child linked using the primary key and foreign keys from the
queries of the two tables. The subform would be a datasheet or continous
form while the form would be a single form view.
Something like --
Joe's Store 123 Brown St. My Town

 

[Guest]

Dear friend,

1) Your Items table contain the selling items? (which are unique)? If so,
2) Create another one (fourth table) e.g. tbl_SalesItems and relate it with
both Items table and Sales table. (one item appearing many times in
tbl_SalesItems)

Ο χÏήστης "r" έγγÏαψε: