Linking text boxes?

[Tegan]

I am designing a form that has the fields: Name, Phone Number, E-mail, then a
sub form with Customer Service Information.
I would like to try and link the 3 fields (name, phone # and e-mail),
together, so if I type in the Name that is already in the database, the
remaining 2 fields appear/fill in with no complications (the sub form appears
fine now).
The name is the Primary Key, and is not allowing me to proceed because it is
seeing it as a duplicate. How can I link these three fields together? They
are together in a table together.
I am assuming a query, but I searched "Auto-fill" and I couldn't figure out
how to do it properlly.
Any help would be greatly greatly appreciated!!!

 

[Jeff Boyce]

Tegan

Your table uses "Name" as a primary key? Since primary keys must be unique,
I guess this mean you will never have more than one "John Smith"!?!

Instead of filling in the "remaining 2 fields", essentially duplicating data
already stored, consider storing only the ID (and I recommend against using
Name as a primary key).

By the way, Microsoft Access treats the word "Name" as a reserved word, and
assigns special meaning to it. Consider changing the name of this field.
Moreover, if this is a "FullName" field, containing first and last names,
your data will prove difficult to sort. Use one field for one fact ...
i.e., FirstName and LastName fields, not a single field with the data all
run together.

Regards

Jeff Boyce
Microsoft Office/Access MVP