https://www.infopathdev.com:443/forums/47.aspxFor questions concerning issues in the integration of SQL and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/78137.aspxMon, 30 Apr 2012 15:25:42 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:78137Kazzahere0https://www.infopathdev.com:443/forums/thread/78137.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=78137<p>Hi</p><p>I have created a very basic form which I want the standard user data such as name, department, manager etc to be autopopulated when the form opens with the details of the user logged into Windows.</p><p>I have created a data connection which seems to be pulling data through when no filter is added, when I add the filter nothing happens.</p><p>I have added the username function as a default value to a control. Then, for example, in the surname&nbsp;control&nbsp;I am setting the value to look at the secondary data source (sql database) for the surname and applying a filter so the username in the secondary data source matches the username on the form, @surname[@WINDOWS_USER_ID = Username]</p><p>I am quite new to IP and don&#39;t know code.</p><p>Would be very grateful for any help.</p><p>Thanks</p><p>Karen</p>