Thanks a lot Craig

Oscar

>>Standard length fields
>>
>>Most of my database design is aimed to Mexico and Latin America. However, this time I need to create a database where common used standard fields will be there for the American and International user.
>>
>>I’ll appreciate any advice about field lengths for the next list of fields.
>>
>>Thanks in advance
>
>
>I'm not sure there is a standard for some of these, but here's what I typically use...some, like phone, SSN and zip are standard.
>
>Phone- 10 (no formatting saved)
>Addres- 40
>City- 30
>Social Security No.- 9 (no formatting saved)
>Zip - 9 (no formatting saved)
>First Name- 20
>Last Name- 20
>Second Name- 20