InfoPath Dev

I was able to include the valve names on this attached form. It doesn't have all the lines but I could add them when this gets figured out.

Thanks. The only thing I didn't see during preview are the valve names. I wish there was a way for me to share the data lists with you. I know this is difficult to do because you can't see the data.

Ok, thanks - I can't see the data, because I don't have access to your SharePoint site, so I have to guess a bit. I've tried adding a filter to the Valve dropdown in this copy of the form, but it may take a few tries to get it right, because I can't see your data. To open this file, you need to download it by right clicking the ...

Here's the first infoPath Form I created without any SharePoint List. Sending this so that you could have a look at the Lines and all the Valve Names. Like I stated my goals for this is to have a cascading dropdown where if I choose the 165L there would only be those 5 valves, but I'm stomped on how to achieve that on my form.

There are 5 entries in Line that are line 165L and each entry does have a valve. Just like the 003L have 8 entries and each have a valve also.

So, for line 165L, are there 5 valves selected? Or are there 5 entries in Line that are line 165L, and each has a valve?

Valve is a lookup on the Line List and it's hard to get a complete understanding of it without actually seeing it.

Glad you got it sorted out, and thanks for posting the info to help others!

I can try! Looking at your data connection, it appears that "Valve" is a lookup on the Line list, is that correct? I think the issue you may have with your data is that we'd only have one valve that would match on a given line. We select Line from the Line data connection, and if we try to find valves that match, there would be only ...

Wonderful - who knows what went wrong the first time, glad you have it working :)