InfoPath Dev

InfoPathers - long time no speak.   All, I have a repeating table with 2 columns. The first column gets its data from another repeating table on the form and is a drop down list of unique values. i.e. Names. The second column is a list of document types. - passport, driving licence, birth certificate If a ...

 Perfecto - thank you so much :)

Thank you so much, you are a lifesaver! I'll keep drinking milk to get close to your level.. Michael

I wouldn't bother with the additional field & would just use a condition if all occurrences of bysinessystems is not equal to QAD - Eagle RF on the dropdown.

 So - you want the library to be used for more than one form type? You need to publish your form as a content type. Then, in the library settings, under Advanced, set the library up to use content types. After you do that, you can specify content types, specify the default content type and so on from the library settings page.

Fixed up form attached. Query fields are used to query for data - so, you set the query fields to the values you want back from you list, execute the query and data is returned to the data fields. Changed data will only post back to the list if the form is submitted. You can control that - set controls to read only, or use calculated values to ...

Sorry if it was confusing, tried to prevent secondary questions. The default QAD printer field is hidden. If I select QAD – Eagle RF from the business systems section I want that field to appear. I also want the field to disappear if I un-select it (hadn't gotten that far though). Business Systems data comes from a SharePoint list. I ...

yeah I was able to do it plus put a rule at the end when you click submit it query's for the latest number then adds +1 and submits.

In an InfoPath form, is there an easy way to clear the data that was previously queried from a secondary data source (i.e. SharePoint list)?  Basically what I've been doing is re-querying that same datasource by setting a query field to a value that wouldn't ever match any records (so no data is returned). For a big ...

Hilary, yes that is the issue, attached template. The other 2 things remaining with the form. The PM pointed out that the fields are bound to the dataFields, which are read write, instead of the queryFields, read only (or are we wrong on this). The PM is saying their is a chance the user could change the values for the fields if the they are ...