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