AddressBook

tblAddressBook is an auxiliary table associated with tblPeople which contains contact information.

   PersonID, integer, 4 bytes, = tblPeople.PersonID
   Affiliation, text, 75 unicode characters maximum, person's affiliation - usually a professional or education organization.
   PhoneNum, text, 30 unicode characters maximum, person's phone number.
   StreetAddr, text, 70 unicode characters maximum, person's street address (';' are translated into carriage returns in the display.)
   CityName, text, 50 unicode characters maximum, the name of the city in the person's address.
   StateProvName, text, 50 unicode characters maximum, the name of the state in the person's address. Selected from a value in tblAddrStates.
   CountryName, text, 50 unicode characters maximum, the name of the country in the person's address. Selected from a value in tblAddrCountries.
   ZipCode, text, 50 unicode characters maximum, The zip or postal code in the person's address.
   Email, text, 50 unicode characters maximum, The person's Email address.
   LastUpdate, smalldatetime, date and time row last updated
   ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change
   CreatedOn, smalldatetime, date and time row was created
   CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row