I would really like to utilise the Absence request form in InfoPath as it is exactly what I have been looking for.
What I would like is the form updating and retreiving the Holiday requests for employees from an access database.
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?