I have a form which consists of a table.
I want to insert some selected value into other table when i update and at
the same time I want it to save into my own table too...
May I know the way please.....
A Form doesn't "consist" of a table. It's like a window, allowing you to see
and edit data stored in a Table.
If you're trying to copy data from one table into another table, and store it
redundantly, you are probably making a mistake. In general, information should
be stored *ONLY ONCE*. Making copies of it into a second table is dangerous,
because if you change the data in one table, it will not be changed in the
second table; you could have "the same" record in your database twice, *with
different values*, and no easy way to tell which record is "the real" record.
What Tables do you have in your database? What information do they contain?
How are they related? You may be making your job harder than it needs to be!
John W. Vinson [MVP]
