InfoPath Dev

Hello I have the following two dropdown below: Column a drop down: A,b,c,d Colunmb b dropdown, 1,2,3,4,5,6,7 When A is select in column a, hide 2,4,6 and show 1,3,5,7 If any other is select in column in that column a it should be the default value, it should only work only when A is selected. Any help will be highly appreciated.

This is something you'll need to use a secondary data source for in order to be able to apply a filter. You can either use an XML file, or, if you are using SharePoint, use a SharePoint list.

Can you walk me through on how I can achieve this?

Are you using SharePoint at all? If so - I'd create a list there for the options. I can create a sample for you with XML tho - but I don't understand this sentence: "If any other is select in column in that column a it should be the default value, it should only work only when A is selected"

Yes I am using sharepoint but currently creating the form in InfoPath. What I meant by saying ""If any other is select in column in that column a it should be the default value, it should only work only when A is selected" Lets see any other option is selected besides option A, the drop down should work normal. Only when option A is selected then it should hide 2,4,6 and show 1,3,5,7. Any other option selected it should work as normal

I think you'll need to at least use a secondary data source (either XML or a SharePoint list) for the second dropdown for "column b" then - will these options change very often? Or are they pretty static?

They are static data, as you mention the XML file be great for this.

See attached. Right click the linked form in the post header, save it locally. Right click the locally saved file and select Design to open in Design mode. Preview to see the filters working. Filter is added to the dropdown selection for the column b dropdown.

Perfect, that works. Do you mind sharing the process and how you store the xml file? Thank you so much. I really appreciate this

Under the data tab in the ribbon in InfoPath designer, there is a "resources" button - the XML file is stored as a resource in the form. You can export it from there, and just add a data connection to your form to the same file - it can be added to the form resources when you add it. If you look at the properties for the column B dropdown in the sample form, and click the field picker for the row for the repeating data, you can see the filter formulas I used to show / hide rows.

Thank you so much. Question: Can this be done without data from external source? can it be done from enter choices manually?

You can't add a filter to a dropdown that has manual choices. You could have two dropdowns if for some reason you want to use manually entered choices - one with all the options, and one with only the options that show when "A" is selected - and use conditional formatting on the dropdown controls to show / hide them appropriately.