Hello davers,
Yes this is very much possible with Infopath.
Please brush up your basics on Infopath by practicing the Infopath labs on MSDN site and also going through the numerous HowTo's and Tricks available on this site
GoodLuck
Kalyan G Reddy
Infopath MVP 2007 and 2008