Auto fill in select queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do i make it so that when i change one value in my query it does not
automatically change other values .
EX. Field called YEAR. I change one record of YEAR 1 to YEAR 9 and all other
records linked to that one change......I don't want this to happen.
 
Presumably your query has linked 2 tables as 1 to many, and the field you are
changing is in the "1" table. To do as you wish requires moving the field
from the "1" table to the "many" table. However this is a structural change
to your database and may cause other areas to break. Perhaps you might add a
new field to the "many" table and use that to store this "year" data?

Madhouse.
 
Back
Top