InfoPath Dev

Thanks Hillary :)  I will have a try with this and let you know how I get on. Andrea :D

Hi Hillary I am quite new to this so I'm sorry if I am confusing you :)    I queried the persons employee details for the first table so that the form knows which person to attach the appraisal form to. However the form also pulls back all of the appraisal information that I had previously entered and I was hoping for a ...

Hi Hillary Many thanks for your response :)  I have indeed added the two tables to my main database connection.  I then tried adding a secondary connection to a sharepoint list to just query the employee table details to see if that would help... but it still queries the Appraisal Table no matter what I do.  The form attached is ...

 Hi All   Does anybody have any suggestions :S 

Hello  I was wondering if I could please ask for some help?   I have an infopath form that I have connected to a SQL database (a test database for now). The database contains two tables, the first table has the employee details in (Employee ID [PKey], Fname, Sname, DOB, Job Role) and the second table has details of any appraisals ...