It sounds like you are storing *duplicated* data in your
database.
In relational databases, you don't normally store
duplicated data. The only exception is the Fields to be
used as the "Linking Fields" between different Tables in
your database.
Perhaps, you should check whether your Database is
structured according to the Relational Database Design
Theory first.
HTH
Van T. Dinh
MVP (Access)
-----Original Message-----
I have two similar but slightly different tables. From
the main table i have a form from which i want the shared
data to be input into the two different tables. Does
anyone know if this is possible. Any help will be
appreciated
