I have two tables that have the same type information. When updating one table with a form, I want to be able to update the other table at the same time.
Since there are 40 fields and I would not know which field might be edited, what would be the best way to go about this? Would I have to have a compID on all rows then have the update command always update all fields? Any suggestions would be appreciated. All fields are text fields. James Belisle
