So today’s exciting task was to find a way to poll our ERP System and grab the open work orders to be used as a picklist in a dropdown in Sharepoint. I also had to extract the valid labor centers and use them in an additional picklist.
Sounds easy enough for people used to doing mash ups, but alas, I am not used to doing them.
So after a few hours and a tech support call to Microsoft’s Sharepoint Designer HOTLINE (Sorry the word HOTLINE next to SharePoint Designer seems funny to me) I’ve got the skinny on how to perform such a riveting task 
PREREQUISITES
- First setup every last one of your Column Data fields. Measure twice, cut once as they say in the construction world
- Order all your Column Data fields appropriately. The same order you want them to show up on the the NewForm.aspx page.
- Open Up SharePoint Designer 2007, and open up your SharePoint site.
- Go to the Toolbox and open your ‘Data Source Library’
- Click ‘Create New Data Source’ under ‘Database Connections’
- Create your connection and query to the database following the wizard
- Create a copy of the NewForm.aspx form and rename it something wittly like NewForm1.aspx
- Double click on the Page to open it.
- Click on the existing web part and change the value between the (IsVisible)(/IsVisible) tags from
True toFalse 
- Make sure the preview window is the active window, and click the right arrow key to advance ever so slightly.
- Insert->SharePoint Controls->Custom List Form
