Okay Fred,

One other possibility would be to automate it so that when you enter a new
person, it automatically loads a set of records in the phone number table for
the common types. So you'd have titles and blanks for the common phone
number types, plus the ability to add others. This would be a lot of work
and complexity to go though, resulting in what many would call bad data.

Yes, this sounds like what I am trying to do.

In my opinion, make the leap, and go with your #3, which is how it's
normally done when databasing things such as yours. It does not have the
restriction/problem that you describe....it lets you put an unlimited number
of phone numbers under each person, indluding repition of the types, if you
so choose.

If I do this, how do I make the form automatically display Business,
Business 2, Business Fax, and Mobile? You know, like you describe above:
"when you enter a new person, it automatically loads a set of records in the
phone number table for the common types. So you'd have titles and blanks
for the common phone
number types, plus the ability to add others."