Select a value from a repeating table based on value entered

[John B]

Business Problem - I have a status report with a summary of projects these
projects can be linked to initiatives.

In another repeating table I have accomplishments (current node) an
accomplishment is linked to a project from the project summary table.
What I want to do is save the initiative on the accomplishment node when the
project is selected for an accomplishment.

I've set a rule when the accproject field is not blank do:

.../../myrojectSummary[../../myrojectSummary/myrojTitle/text() =
..]/../../myrojectSummary/myrojTransProj/text()

Any help would be appreciated.
Thanks,
Thanks

 

[John B]

Never mind. A friend showed me how to use the filter menu when creating the
rule so InfoPath builds the xpath.