Programming multiple phone lookup list for contacts in access

  • Thread starter Thread starter Jerome
  • Start date Start date
J

Jerome

How do I program mulitple lookup phone list in access; i.e.
Enter record in data sheet, insert name, etc. then come to
drop down list and have all numbers available for each
person on my record.

sample field format;

Sir,nick,First,m,Last,Title then PHONE dropdown which
would allow data entry for
W:PhoneNumber,H:PhoneNumber,Cell:PhoneNumber and so on.

Ideal format would allow the user to read across the data
sheet then select from the drop down list for work number,
home number, cell number etc.
 
How do I program mulitple lookup phone list in access; i.e.
Enter record in data sheet, insert name, etc. then come to
drop down list and have all numbers available for each
person on my record.

sample field format;

Sir,nick,First,m,Last,Title then PHONE dropdown which
would allow data entry for
W:PhoneNumber,H:PhoneNumber,Cell:PhoneNumber and so on.

Ideal format would allow the user to read across the data
sheet then select from the drop down list for work number,
home number, cell number etc.
Click to expand...

Well, that would *not* be the ideal design for your Table. "Fields are
expensive, records are cheap" - typically one would have two tables in
a one to many relationship:

Contacts
ContactID Primary Key
Surname
Nickname
First
<etc. etc.>

Phones
ContactID
PhoneType
Phone

You'ld use a Form (NOT a table datasheet, they're very limited and
best reserved for debugging) based on Contacts with a subform based on
Phones.
 
Back
Top