Realtionship help and updating db

Hello and thanks in advance for your help! I have a small website that I maintain for my employer's company. I have used access for quite awhile as my database to log sales each month and keep track of how the employees are doing and how the month is looking. As it is right now I have every table seperate and employees have to edit each table with new information. I would like to be able to update each table from one form. I have been trying to understand relationships and have read books on this. However, I am for whatever reason not getting it. Here is the basic info that I am trying to tie together.

Store:
Store name

Employee:
Employee name
Item1
Item2
Item3

Customer:
Name
Personal Info
Employee name
Item
Store name

We have only 3 things we sell and I would like for my employees to be able to enter the customer info along with the Employee, Item,and Store info. I think I can create a relationship for the Employee Name and Store. However here is where I run into problems: As the customer purchases an item I would like it to tally into the Employee info. (example, we sell phones so If John doe buys 2 item1s from Jane then when I look under Jane's Name then she would have 2 item1s sold) I hope this makes sense. It seems fairly easy, but I just can't get it. Thanks again!

J

J
i'm having the same problem. The only way I can think of is to run and update query on the appropriate tables after you've entered the new record. The way I understand it, relationships will only cascade changes to existing records. If you find a better way, I'd love to hear from you.

Have a look at the Northwind database in the sample databases for a start.