Form does not update when new records are added to Primary Table

[DecaturLady]

I'm fairly new to Access, having played with it since V2003.
Currently, I'm working on a database to be used as the source for a Reunion Class Directory. There are six tables: Names - Phone numbers - Email Addresses - Physical Address - Mailing Address (i.e., PO Box) and Photos.
All the tables are linked one-to-one using the autonumber ID.
My form uses all but the Photo Table. I began with ~550 names. Other names have since appeared and I have successfully used the append query to add them them to the Names Table.
These new names appear in queries, but I can't figure out why they are ignored by my form.



Please help a very confused DecaturLady!

PS: I don't do coding yet. That's another project!!!

[pbaldy]

If the form is based on a query that joins the tables, you'd have to either edit the join(s) or make sure there are records in the other table for each name. Normally you'd use subforms for one-to-many tables. If yours are really one-to-one, I don't see why they aren't just fields in the names table.

[Missinglinq]

For this kind of database, are you really expecting to have multiple email addresses, multiple phone numbers, etc., for each classmate? That's the only reason you'd need to have separate Tables for each type of data. Unless this is the case, having separate Tables, like this, is really over-normalization, and only going to complicate things. Even if you want a home phone/cell phone and a business phone, it would be better to have a field for each in a single Table.

Linq ;0)>