InfoPath Dev

Tough! :) I'm guessing in your DB you're allowing NULL for these fields (coz you can't have an ''empty'' value for a date). Exactly the same issue arises for any field type which does not allow an ''empty'' value (e.g. a string can be '''', but an integer must have an integer value, or you can allow NULL, but it can't have an ''empty'' value as ...

I have a scenario that I'm using 2 tables. The record always exists in Table 1, but, may or may not exist in Table 2. My query dropdown is based on Table 1. When this is selected the Data Information is populated. The Data Information may or may not consist of data from Table 2, depending on whether or not data has been entered into Table 2. ...

Currently all my DatePickers on my InfoPath form are required, or expecting the datetime format (red asterick). I want to be allowed to leave these fields as blank. I'm using SQL - Web Service (which contains my Dataset) and InfoPath. I'm basically passing an empty value, thus the DatePicker will not display anything if I select someone from my ...

Greg, First off, I think congratulations are in order, according to the other poster! :) So congrats to you (you must be mad...) Thanks for pointing me in the non-master/detail direction, at least that's a start! I (think I...) have solved my own problem, at least a bit, and posted to MS communities IP to that effect. A lot of my probs are to ...

I'm not suer how much I'll be able to help on this one, but let's try: First of all a master/detail control is probably not the choice for you. Reason? Because it expects there to only be 1 table on the back end, not 2. What it really sounds like you need is some way to select an order, have one section show the details of the selected order, ...

Gregs very busy, I'd give him alot of time to respond. Also with a new child it makes it that much harder. :-)

Bump (Greg?) :)

I am having a problem because Infopath will not allow me to bind a repeating table to query fields. What I need to do is be able to edit and submit several rows of records in an Access database at one time from my infopath form.

SOLUTION: When you publish the form to Sharepoint the form will be listed as a Document Library (or whatever you named it). Select the ''Fill Out This Form'', but before you actually fill out the form, select File -> Save. This will save the template. Of course, you can see that there will be a few issues. Mainly , for each form that you ...

It actually will be bound to a secondary data source (a different web service). Not sure, if I actually need to make this one my Main Data Source, or not, since it is the first one being called. It will consist of a PositionID and PositionText. But, I run into problems trying to select the PositionID when I use the secondary data source. In the ...