Projected fields are a nice way to join lists and show fields from related lists in the same view without physically duplicating fields. Unfortunately, these projected fields are not available in InfoPath data connections. I am now tempted to duplicate data
and to maintain physical copies of fields in multiple lists to overcome this limitation, but it makes me uneasy ;-)
I must add, the InfoPath form is a list based form without code behind.
If you guys have a better idea, please let me know. thanks.
View Complete Post