Help, editing records!

  • Thread starter Thread starter Melissa
  • Start date Start date
M

Melissa

Hello,

I have a table with 8 fields. The first 3 can be common
for many entries. Id like to create a form that only
shows the first 3 fields and if you edit any of them, it
will search the entire table for the field you changed
and change them all.

for instance if you change ID # from 1 to 2, all product
numbers with 1 (regardless of other fields) will change.

Thanks

Melissa
 
Hello,

I have a table with 8 fields. The first 3 can be common
for many entries. Id like to create a form that only
shows the first 3 fields and if you edit any of them, it
will search the entire table for the field you changed
and change them all.

for instance if you change ID # from 1 to 2, all product
numbers with 1 (regardless of other fields) will change.
Click to expand...

It sounds like you actually should have *two tables* - related one to
many. The three fields would be in the "one" side table, and the many
side table would have the other five, plus a "foreign key" link to the
one side table. With this proper relational design, you need change
the data only once.
 
No, this happens thousands of times, i dont want to make
things more difficult for nothing.
Click to expand...

<shrug> I'm suggesting making it easier, not more difficult.
"Thousands of times"??? What do you mean?
 
Back
Top