Steve Schapel
steve at datamanagementsolutions.biz
Wed Aug 24 19:47:21 CDT 2011
Hi Martin I would expect a query including both Table2 and Table3 to be updateable. If it's not, can you give some more details? Regards Steve -----Original Message----- From: Martin Reid Sent: Thursday, August 25, 2011 4:59 AM To: Access Developers discussion and problem solving Subject: [AccessD] Sub Form I know this should be easy but Whats the best way to display data form two tables in a sub form. Table one single PK. Table 2 Multiple PK, table 3 single PK Main form displaying table 1 Sub form showing data from table two and three and can it be updated.