A
Arnold Roth
I have a database that consists of several linked tables.
Now I'm finding it necessary to add an additional field to
one of the tables. This will require that several new
records will be added to that table.
I have a query that basically selects all the fields and
have been trying to update the d/b in that query. The
problem is that when I update an entry that points to the
altered table all the entries that were previously the
same are updated to whatever the last change I made was.
The problem, of course, is that the links to all those
records was the same and is not being changed.
Is there any way to update the records so that the links
are updated without my manually updating each one?
Thanks for the help.
Now I'm finding it necessary to add an additional field to
one of the tables. This will require that several new
records will be added to that table.
I have a query that basically selects all the fields and
have been trying to update the d/b in that query. The
problem is that when I update an entry that points to the
altered table all the entries that were previously the
same are updated to whatever the last change I made was.
The problem, of course, is that the links to all those
records was the same and is not being changed.
Is there any way to update the records so that the links
are updated without my manually updating each one?
Thanks for the help.