table problem

[gvaughn]

I have two tables 1. Client 2. Customers. As of right now the order entry
person is using the Client table, and any data inputed is contained in that
table. The Customer table is a new table that is going to be implemented with
a new interface for the order entry person. When I first created the Customer
table when she would update the Client table the Customer table would also be
updated with the new data. Sometime in the past 4-5 days the Customer table
has stopped updating when the Client table has been updated. To my knowledge
no major changes have been amd to this table. Any suggestions on why it would
stop updating and how to fix it would be greatly appreicated.

Thank you,

 

[John W. Vinson]

I have two tables 1. Client 2. Customers. As of right now the order entry
person is using the Client table, and any data inputed is contained in that
table. The Customer table is a new table that is going to be implemented with
a new interface for the order entry person. When I first created the Customer
table when she would update the Client table the Customer table would also be
updated with the new data. Sometime in the past 4-5 days the Customer table
has stopped updating when the Client table has been updated. To my knowledge
no major changes have been amd to this table. Any suggestions on why it would
stop updating and how to fix it would be greatly appreicated.

Thank you,

WHOA. Several problems here!

First off, users should never even SEE tables. They should interact with data
using a form. This gives you a lot more flexibility, programmability, and
control.

More critically, it appears that you're storing data redundantly in the Client
table and the Customer table. Redundancy is bad, because it's redundantly
redundant. Each table should model a particular class of Entities; all of the
information about one instance of an entity (a Customer let's say) should be
in that table *and noplace else*. I have no idea how entering data into a
Client table *EVER* caused data in the Customer table to be updated, but if it
was, it shouldn't have been!

What are the actual tables in your application? How are they related? What, in
the real world, is the relationship between a client and a customer?