I get the following error when I try to "Store" a new Item in the database even though the record is successfully inserted into SQL Server:
"Unable to Save Item (SyncFolder)"
I also get an error when I try to modify a record in Outlook:
"A field on this form requires a value."
I am unable to "Load" items back into Outlook.
My config settings are as follows:
[Fields]
# Format: outlookfield=column,conversion
Business Address City=City,
Business Address Postalcode=Zip,
Business Address State=State,
Business Address Street=Address1,
Business Fax=Fax,
Business Phone=Phone,
Company (Name)=CompanyName,
Email=Email,
First Name=FirstName,
Initials=Initials,
Job Title=ContactTitle,
Last Name=LastName,
Mobile Phone=Cell,
Radio Phone=RadioID,
User field 1=ContactID,
User field 2=ContactTypeID,
[PrimaryKeys]
# Format: column=newstatement
ContactID=select (max(ContactID) + 1 ) from tblOutlookContact
[MandatoryKeys]
# Format: column=newstatement
ContactTypeID=select -1
-Tim