Re: Infopath 2010 Relational Text Boxes

Hilary Stoupa — Fri, 04 Nov 2011 19:57:02 GMT

Hi - I think I just replied to your other post - the issue you are having is with your filter.

Drag your secondary data sources on to your form and preview. Then you can see what the data actually is that is returned. I think the values in your lookup columns may have the format of ID;#Display - in which case you'll need to do a more complex formula to get a match.

Infopath 2010 Relational Text Boxes

csigler — Fri, 04 Nov 2011 16:32:54 GMT

I have a SP2010 Contact list with Company Name and Phone.

I Have a SP2010 Lead list with Lookup to Contact list>Company Name.

My InfoPath 2010 form has the Company dropdown: Cannot be blank, Get choices from an external data source, correct source listed, entries are pointed at the group level with value of ID and Display being the Title(Company Name). I have a phone text box i created on the field with the value being Contact list>Phone and a filter set to Contact>title is equal to Main>Company.

Now my problem is this:

With those settings my Company dropdown works great but phone does not display. To test if i make phone simply equal company the ID is displayed therefore I see why my filter is not working.

If I change Company dropdown: Cannot be blank, Get choices from an external data source, correct source listed, entries are pointed at the group level with value of Title(Company Name) and Display being the Title(Company Name) my dropdown works great and phone is properly populated BUT I get that horrid error that ONLY POSITIVE INTERGERS can be used for Company.... and my form won't save.

Sounds like I need to edit my filter but i don't get what it should be.

Corrie