There is a blog entry from Stefan Cameron that describes this and has
examples. Here is the basic
one:http://forms.stefcameron.com/2006/09/18/connecting-a-form-to-a-database/And
here is the more advanced get a specific record
one:http://forms.stefcameron.com/2006/09/29/selecting-specific-database-records/I
also did a webinar on this topic .....here is a link to that
webinar.http://adobechats.adobe.acrobat.com/p69655795/?launcher=false&fcsContent=true&pbMode=normalPaul