Hi All,

I am facing the following issues in Infopath 2007:

1) A user opens up an infopath form having 2 dropdown boxes. The data in the
first dropdown is coming from a SP list (Lets say 'Projects') while the other
one is hardcoded. The 'Projects' list in SP contains 2 columns as below:

Project Name             Flag
___________           ____

A                                   0
B                                   0

The user selects  an item from the first dropdown ( Lets say 'A') and from
the second dropdown selects some value and submits the infopath form. Now the
SP list row 'A' (selected by the user) should have a flag set as 1 as below:

Project Name             Flag
___________           ____

A                                   1
B                                   0

Here we require a solution without using any custim coding.

2) In the same scenario once the flag column corresponding to a project has
been set as '1' as above the value 'A' should not be available for selection
to the user in the first dropdown of the same infopath form.

A prompt response shall be highly appreciated. Thanks.