InfoPath Dev

Hi All, So My background is more in Access than in Infopath so I might be approaching this in the wrong way but here is the situation. I have an infopath form that is used to write referrals, alot of demographic information which is stored elsewhere gets typed in manually and I would like to sort this used some data stored on a VIEW in SQL ...

Hi,  I work at a Hospital for the NHS and I am setting up an InfoPath form to be used to input and query patient details from my area. I am going to publish this form onto one of our shared drives for other users from other computers to access it. Due to the confidential nature of the data I am obligated to keep this information secure ...