https://www.infopathdev.com:443/forums/45.aspxenCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/14694.aspxFri, 23 Jun 2006 23:55:31 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:14694Greg Collins0https://www.infopathdev.com:443/forums/thread/14694.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=14694For the first question -- you can set a Default Value Formula on your main DOM field which just copies the value of your 2DS (secondary data source) field.https://www.infopathdev.com:443/forums/thread/12908.aspxThu, 22 Jun 2006 18:12:04 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:12908kaosweb0https://www.infopathdev.com:443/forums/thread/12908.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=12908I am having some problems getting started with some scripting I am trying to put on a form - can anyone help.<br /><br />My background:<br />-Newbie to Infopath<br />-familiar with vb and js - but a little rusty.<br /><br />My situation:<br />I create a form that will be hosted on a sharepoint site. The work flow of the form is as follows...<br /><br />1. Users fill out form - submit<br />2. Authorized group goes in - reviews form gives an approval (using sharepoint content approval system)<br />3. User should be able to go back and read his own form, and edit at anytime (no other user should be able to read/edit)<br /><br />My thoughts/assumptions:<br />-Create customer sharepoint view to filter by users form - peice of cake, already did this<br /><br />-Remove explorer view so users cannot edit form in notepad<br /><br />-store users id in form in hidden field, valid when they open form, that they match the creator id, if not close form and alert user of permission issue.<br /><br />- user edits their form, the form goes back to pending state and the process starts again - sharepoint keeps version history of form.<br /><br />Areas I need help....<br /><br />I have create an empty database with public access using windows auth. I select the username and bind it to a txt field. This gives me the creator.<br /><br />Questions...<br /><br />How do I take this field thats binded to my secondary data source and store in form field.<br /><br />How do I then reference binded field and check against creator field store in form - I just dont know how to reference secondary binded source field.<br /><br />I tried a bunch of stuff - can you help...