My Person list has a lookup to the various companies for whom they could work; each person will only have one company.
The Company list has several fields corresponding to that company: address, phone, manager, etc.
In Sharepoint I created a lookup field on the Person list to the Companies list by Title (seems safe that there won't be duplicate titles), and then "included" the Address, Phone, and Manager name of the company to make a total of 4 fields in the Person list that "come from " the company list.
Works great, I select a company, all 3 other fields populate.
THEN I created my InfoPath Web Form based on the Person list, and it created the a secondary source to "Companies", and the drop down shows me Company names (title), but I can't "see" the rest of those fields....they aren't in the "Main" connection, and the only 2 fields in the Secondary Companies connection are ID and Title w/ no editting available.
It seems to me that the rest of those Company fields should be "available" for me see from the Infopath form.....somewhere...????
My effort to solve this myself (which didn't quite work): I created a NEW secondary to the Companies list during which I could select those additional fields........ I can see them in the new Company secondary source datafields, but draggin them onto the form get added as a "repeating table" which I don't want/need.
What I'm tryin to do is :
When the Infopath user selects a Person to edit, the form fills with that record's field data, they should be able to select a company & have all that company's data fill....and/or, when they select a Person to view, the previously selected company with all the info is read-only visible.
Seems easy, but I'm a little wrapped around the axle here.....can somebody explain where I'm going wrong? How to get the selected company "title" field in a dropdown to populate the Address, Phone, Manager fields on the form?