SQL Database Integrationhttps://www.infopathdev.com:443/forums/47.aspxFor questions concerning issues in the integration of SQL and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)Re: Absence Request form into Accesshttps://www.infopathdev.com:443/forums/thread/16969.aspxFri, 29 Dec 2006 16:48:30 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16969wwudave0https://www.infopathdev.com:443/forums/thread/16969.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=16969Rabbitmo -<br /><br />Did you ever figure this out? I also would like to use the Absence Request form and connect it to an Access database.Absence Request form into Accesshttps://www.infopathdev.com:443/forums/thread/16724.aspxTue, 02 Aug 2005 12:23:17 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16724rabbitmo0https://www.infopathdev.com:443/forums/thread/16724.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=16724I would really like to utilise the Absence request form in InfoPath as it is exactly what I have been looking for.<br />What I would like is the form updating and retreiving the Holiday requests for employees from an access database.<br />I have imported the Schema from the Absence request template into access and think I have to create the primary keys within the database. Is this the correct way to go about this ? If so what is the best way? Should I use EmployeeID thoughout all the tables or have an Id feild for each table and have all these in tblEmployee?