InfoPath Dev

Clay,  Thanks for the reply.  Is there a way I can send you the mdb file in zipped format to explain further?  Thanks, Steve

Dear All, I have created a small database in MS Access with three tables. Customers (ID and NAME) Sales (ID, CUSTOMER_ID, REVENUE) Purchases (ID, CUSTOMER_ID, TURNOVER) In MS Access these tables are linked via the Customers.ID, Sales.CUSTOMER_ID and Purchases.CUSTOMER_ID. I have tried to create a form in Infopath to capture this data. ...