So the problem is you are getting the values from the first record not the
one selected?
A filter is what you need to say set the values but where jobnumber = WBS1.
That way you get the data for the correct record.
I work with databases and InfoPath every day.
If you want to email me I could show you some examples.

Signature
Clay Fox / Microsoft InfoPath MVP
www.InfoPathDev.com / The InfoPath Authority / Downloads, Samples, How-To,
Experts, Forum
> Hello
>
[quoted text clipped - 18 lines]
>
> and thats it. Any ideas?
AugieT - 26 Mar 2008 17:54 GMT
It would be really helpful to see some code here in the blog - this standard
answer of e-mail me doesn't help the rest of us out in cyberspace.

Signature
> So the problem is you are getting the values from the first record not the
> one selected?
[quoted text clipped - 28 lines]
> >
> > and thats it. Any ideas?
Clay Fox - 26 Mar 2008 18:21 GMT
Sorry I usually add the link for my email.
http://www.infopathdev.com/members/clayfox.aspx
How are you planning to connect to the database?

Signature
Clay Fox / Microsoft InfoPath MVP
www.InfoPathDev.com / The InfoPath Authority / Downloads, Samples, How-To,
Experts, Forum
> It would be really helpful to see some code here in the blog - this standard
> answer of e-mail me doesn't help the rest of us out in cyberspace.
[quoted text clipped - 31 lines]
> > >
> > > and thats it. Any ideas?