After I posted this, I was able to get information from the secondary data
source (SharePoint) and put it in the default data field. The problem that I
run into now is when I apply a filter to retrive data from the correct row in
the SharePoint list, I only get the 'lowest' row accessed (now, if I am
making sense).
For emaple:
A share point agenda list:
SUBJECT OWNER DURATION
New Business Bob 5
Old Business Sue 10
Discussion Tom 15
So on the form, I make the subject a combo box and I want the Owner and
Duration field to be populated with the corresponding data. To do so I set
the default values of both fields to pull from SharePoint and I apply a
filter to match the subject in SharePoint with the subject in the combobox.
These 3 fields are in a repeating table.
When I go to fill out the form, these are the resuts:
Attempt 1 (picking the first choice--Only the first row is correct)
SUBJECT OWNER DURATION
New Business Bob 5
Old Business Bob 5
Discussion Bob 5
Attempt 2 (selecting the second choice first--The first two are corect and
any more show up the same as choice 2)
SUBJECT OWNER DURATION
Old Business Sue 10
New Business Bob 5
Discussion Sue 10
And so on (if I choose the third, I get three corect, and the rest fail).
I am at the same point. . .at my wits end.
> I am trying to do this too! I have tried a few different things and nothing
> is working. I just looked at this example:
[quoted text clipped - 7 lines]
>
> Nothing is happening, and I'm not sure what to do next...
BethA - 28 Dec 2005 21:05 GMT
You're doing better than I did - I'm not getting anything to populate. I'm
wondering if I'm having a problem with needing to trim the text.
Have you looked at any of the posts that mention using current()? I didn't
quite figure that out, but it might relate to your problem.
Good luck - I'll let you know if I find anything else out.
Beth