InfoPath Dev

Normaly with most forms that I create I set each fields background color to yellow if the cell is blank. This way my users know what fields they have to fill out as soon as they open the form.  But this dosn't seem posible with the people picker control.  There is no way to set the formating by using a rule other than to disable the ...

You'll need to create a secondary data connection to your SQL table (you have DBXL, so you can use QueryDB for that). Then, the tricky bit is going to be copying your secondary data into your main data source -- Basically, you'll need to insert how ever many number of rows returned by your SQL query to your main data source. Then populate ...

Patric thank you for the responce.  Though I did figure out that I could incude the second table in the original data connection and acheave the same results.  Thank you for your help, Steve

I wanted to report back that I set up a SharePoint Designer workflow using the item level permissions tutorial (link I previously posted) which utilizes a codeplex download called "Useful Sharepoint Designer Activites .5 Alpha" and it works fabulous!  Not only does the form only open for the designated ...

Since you are submitting your data to the "CYLINDER_MEASUREMENTS" table, you need to have that be the table you use for your data connection. "CYLINDER_DATA" would be a secondary data connection in your form. Your drop down where the user selects the Cylinder Id would use the Cylinder Data data source to provide it's ...

Can you let us know if Jim's exclusion to the web.config solved the issue for you? Thanks Ted

No answer yet. :( Not possible? Wrong forum? Am I just retarded? Is my deoderant not working anymore? ;)

I think you are saying that when you view the form in the browser, one control doesn't display the default value? Is this a default value? Does it depend on a secondary data source? Are the post back settings the same on all the controls? For IP 2003, the order of processing on startup is user roles, open rules, OnLoad ...

thats exactly what i want to do, and unfortunately i dont have much experience with infopath or sql

So, I think what you are saying is that when the form is opened, you want to have a table with all the traits and the user can select a rating for each trait? Then the user submits, and the data goes into your target table? The tricky bit then is that you'll need to insert groups into your main data source, and copy in the Traits -- because ...