Thanks Walt. So now I have two ways to approach this. Your suggestion
involves a lot more changes to the basic database structure where mine are
more cosmetic. Do you or does anyone know the asnswers to the following
questions:
1) Will international phone numbers be supported as described below in Ver
2?
2) What is the best way to adapt now so that I don't have to re-enter data
if I upgrade? Yes, we do have a reasonable number of these entries.
Thanks
David Rodgers
Institute for Individual and World Peace
> >What is the proper way to enter international telephone numbers.
>
> If you have a bunch of these it might be worth changing the
> validation criterion of the phone number field to accept 8 digits.
> You would also have to change the display field to put the hyphen in
> the right place. This works only if you have FileMaker, and can
> change the layouts and field definitions.
>
> >Take for
> >instance we have Australian numbers that have the format:
> >
> >61 - 2 - 1234 - 5678
> >
> >61 is the Country code (in the US it is 1)
> >2 is the city code (US area code equivelent)
> >the last 8 digits are is the telphone number (7 digits in the US)
> >
> >So the end result is I end up with one more number than will fit into the
> >field. In some countries the city code is two digits so I would have even
> >more.
> >
> >One way I can see to enter this and to see the result on the HOME screen
> >is to put the country code (62) the city code (2) and number of the eight
> >digit telephone number into thethe HOME AREA CODE field and then change
> >the HOME layout to extend HOME PHONE field display size to show all the
> >numbers.
> >
> >I can't add the 8 digit number into the HOME TELEPHONE NUMBER field
> >because it only excepts 7 digits in the current layout.
> >
> >Is there a better way? Has someone figured this out yet?
> >
> >David Rodgers
> >Institute for Individual and World Peace
> >
> >------------------
> >Reminder to each recipient: To change your list account preferences, go to
> >http://email.sparklist.com/scripts/lyris.pl?enter=support and enter
> >the email address you used to subscribe to the ebase support list::
> >[EMAIL PROTECTED]
> >
> >To unsubscribe send a blank email to [EMAIL PROTECTED]
> >---------------------------------------------------------------------
> > ebase - Relationship Management for Nonprofits, http://www.ebase.org
> >---------------------------------------------------------------------
>
> --
> --
> Dave Shaw H4 Consulting
> tel: 206-954-7526 fax: 206-625-1338
------------------
Reminder to each recipient: To change your list account preferences, go to
http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address
you used to subscribe to the ebase support list:: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------------------------------------------------------------------
ebase - Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------
