Store SubForm Information

T

Tim

I have employees who changes names, departments, job titles, when I update
the main table (SdDirectory) with the new information all the pass and future
records incorporate the new information. My queries are incorrect for
information related to any of specific field. If I use a sub form to pull
information from tables that information might change, I want to design a new
data base to be able to store the original information. Does this process as
something to do with the way the table relationships are set up? I am using
Access 2003; I greatly appreciate your assistance.
Tim
 
Top