Please could you expand this concept??
I was going to post a new thread when I came across this one that seems exactly my problem.
Below is what I was going to post.
First at all Hi to everybody... this is my first post, so please bare with me...
So I have this Infopath Web Form to document payments for treatments provided in a doctors office. The data for each treatment is coming from a SQL DB.
User would select the patient in question first from a combo box retrieving tha patient and treatments data from a secondary connection to the SQL DB.
This Web Forms contains a repeating table to enter multiple treatments to be paid in the same receipt, after the patient name is selected.
Once the patient is selected, another combo box within that repeating Table is populated by filtering only the treatments for that particular patient only.
My question is how can I filter previous selected treatments from the options offered by the treatment combo box?
Let say the user choose patient "Jhon Doe" from the first combo box "called "Patients".
When goes to select the first row in the repeating table "treatments" he gets several options like
A
B
C
D
E
User selects B and inserts another row on the table.
Now when he goes to select a treatment he should be able to only see
A
C
D
E
(NO B)
Now, D is selected, and another row is inserted.
When the combo box is displayed again, it should show only the following options
A
C
E
(NO B or D)
and so on.....
I've found some articles using filters like NOT and PRECEDING, but I understand that this are only available in "Form Filler" forms....
http://www.infopathdev.com/blogs/matt/archive/2006/05/23/Filter-a-Repeating-Drop_2D00_Down-List-on-Previous-and-Future-Selections.aspx
How do you achieve the same in a Web Browser compatible Form in Infopath 2010???
Thanks in advance