See this article http://enterprise-solutions.swits.n...ial-db-table-record-navigation&c=infopath2003
which describes part of the solution for you. The other part for adding and
deleting records you can get when you bind your form to the database. Both
solutions are codeless. But you can write code to do all of this too if you
wanted to.