In this series of post, I’ll show how you can integrate Microsoft Office SharePoint Server 2007 with another line of business system, more specifically Dynamics AX. The purpose is to create a custom field type, which can be added as a column to a SharePoint list. This SharePoint column renders a dropdown box with values from a Microsoft SQL Server table’s column. As such, in stead of duplicating the possible values on your SharePoint box each time new values are added in your line of business system, the available values for this SharePoint column are always in synch with your line of business system. This first post describes how to create your connection between Microsoft Office SharePoint Server 2007 and Dynamics AX. The second post describes how to create the custom field type. Currently however, the DAX project activities we are receiving in our dropdown list are based on a specific project. In this post, I’ll describe how to receive those project activities for a project depending on the site the issue list is part of.