Linking

[Guest]

Hi, I have about 8 fields (all from the same table) and what i need is when i
change a value in one field is to have all the other values change to
correspond with the value that i changed.

Thanks in advance,

-Robert.

 

[Allen Browne]

Robert, if you have several fields that all should change when the first one
does, you have a design that has dependent data.

The solution will be to redesign your table(s) so this does not occur. It
violates the most basic rules of data design.

It may not be immediately obvious how to do that. The keyword to search for
is "normalization." Here's a starting point for your study:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html#DatabaseDesign101