Hi em,
I looked at what you wrote and the line is:
<xsf:xDocumentClass trustSetting="automatic" dataFormSolution="yes"
solutionVersion="1.0.0.4" productVersion="11.0.6357"
solutionFormatVersion="1.100.0.0" publishUrl="C:\Documents and
Settings\monsoun\Desktop\InfoPath\forms\manifest.xsf"
name="urn:schemas-microsoft-com:office:infopath:forms:-dataFormSolution"
xmlns:xsf="http://schemas.microsoft.com/office/infopath/2003/solutionDefinition"
xmlns:msxsl="urn:schemas-microsoft-com:xslt"
xmlns:xd="http://schemas.microsoft.com/office/infopath/2003"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xdUtil="http://schemas.microsoft.com/office/infopath/2003/xslt/Util"
xmlns:xdXDocument="http://schemas.microsoft.com/office/infopath/2003/xslt/xDocument"
xmlns:xdMath="http://schemas.microsoft.com/office/infopath/2003/xslt/Math"
xmlns:xdDate="http://schemas.microsoft.com/office/infopath/2003/xslt/Date"
xmlns:q="http://schemas.microsoft.com/office/infopath/2003/ado/queryFields"
xmlns:d="http://schemas.microsoft.com/office/infopath/2003/ado/dataFields"
xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution"
xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2004-11-19T16:23:21">

This question relates to this link that is why I am asking
(http://groups-beta.google.com/group/microsoft.public.infopath/browse_frm/thread/
52371b4bdf965ddd/0de40c8764d9ec00)
but i do not see where the namespace is declared. Am I looking in the
wrong spot?

So now that I can get the expression box to return information from the
SQL db i am half way there. It seems that I can only produce the first
entry from the db. I am filtering what shows in the expression box by a
choice made in a drop down list box (company) and each company has
several departments (these are supposed to show in the expression box).