Kelvin,
Not quite sure why you felt that Table1 needed to be
replaced. It is more usual to modify or update a table than
actually replacing it. What has probably happened is that
Access transferred the existing relationship for the two
tables even though you renamed one. What you may need to do
now is to go to the Relationships window and delete all of
the relationships, close the window saving changes and then
reopen it and define the new relationships.
While you are at it, you may want to give serious
consideration to renaming your tables in a more descriptive
manner. Table1 is probably the name that Access gave it. You
can rename it to whatever you want. tblCustomers would be a
good name for a table that stores customer info. Do this
before you recreate the relationships.
--
Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
message
I have an access form and subform that are linked to
different queries. They have a common field that links the
child fields and master fields. Now the main table these
queries come from was changed. Table1 needed to be replaced
so I called it table1_old and replaced with table2 that I
renamed table1. When trying to enter the data in the subform
I get the following error: "You cannot add/change a record
because a related record is rquired in table1_old"
Why is it looking at table1_old. I checked all the
queries and they have the right table name. Any sugestions?