-
In Reserved Material, on SharePoint, in the list settings, I would make Tracmor number a lookup column that looks up the Tracmor number from the Stock list. That way you can only select valid numbers. After you do that, walk through the data connections in the form again to update them. Then, your comparison for the dropdown where you wish to only ...
-
The second screenshot doesn't make sense to me - is the column really a choice with the default values you show? Based on the screenshot of the list data, though, I can see the Reserved Materials list has text entered for the number & the stock list has a number value. This could be causing the comparison issue. Are these lists in use ...
-
That screenshot on the left is for options for InfoPath 2010. You need to install Visual Studio Tools for Applications for VS 2012 - have you?
-
Can you send the screenshot from the Reserved Materials instead? Is that column a lookup type in Reserved Materials?
-
Attach a copy of your form under the options tab in a reply & I can take a look.
-
Your database tables have none of the types that cause Submit to be disabled? Those are the only 2 things I know of that cause this. Form compatibility and data types.
-
I'm going to guess that Tracmor in the Reserved material list is a lookup, and that the Reserved material list data would actually be storing the item ID. I've modified your expression on the dropdown for that scenario. If you can give me additional info on the Tracmor column in the Reserved material list (like a screenshot of the column ...
-
Can you attach a screenshot under the options tab in a reply showing the problem? Your idea is correct - you'd use Disable if All Occurrences of WhateverField are blank - but there isn't a reason I can think of that you can't access (?) the fields of the repeating table.
-
Oh, one more question. Is Tracmor number in "Reserved Material" a lookup?
-
I think your question is how to count all the selections that are not N/A? So count(pathtofield[. != 0]) ought to do that.