My db contains names, contact info, etc., for my high school class. It has six tables. [Names, Phone numbers, Email addresses, Physical address, Mailing address, and finally photos. [Names is my primary table, Relationship to other five tables are all directly from the Names Primary Key ID to the Primary Key ID of the other five tables.]
There are 500+ records. The original "official" list was painfully converted to the db and data checking began. I created a query to combine the data from all the tables (except photos). Then I created a form ("Kitchen Sink") based upon that query. So far so good and everything was going GREAT!
Trouble began with error checking and we found about 16 classmates were missing from the original list. I used an Append Query to update the names table. NOW, the BIG PROBLEM!!! When I go to my Kitchen Sink form, the new records are not there! I'm stumped!!!
Do I need to delete the form Kitchen Sink's source query and create a new one?
Do I also need to create a new Kitchen Sink II form based upon my new query?
I need HELP in a BIG way. Fiftieth Reunion is ~ten months away. Data is very stale and I need to get this fixed so I can contact classmates to obtain corrected information.
Can anyone help me? Please!!!
pam