William Benson (VBACreations.Com)
vbacreations at gmail.com
Wed Aug 24 17:47:42 CDT 2011
True. Best. But to accomplish the need, if the tables have the same fields (or can be coerced in such a way that you can query from them the same required data in the same order) I would make a single form use a recordsource that is a union query like Select "1" as MySource, Fld1, Fld2, Fld3 from Tbl1 Union all Select "2" as MySource, Fld1, Fld2, Fld3 from Tbl2 You can order by Fld1, MySource (assuming Fld1 is the right index - or create another, which is common to both tables, using some other interrelated queries) If you display this in DS view, the each pair of records should show one source atop the other. Gets dicey when one table has a certain value for Fld1 and the other does not. Might want to find a way to insert null records through additional query steps. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Wednesday, August 24, 2011 6:35 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Sub Form I'd go with two sub forms. Seems the simplest way. R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid Sent: August 24, 2011 10:00 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. Martin Martin WP Reid Information Services The McClay Library Queen's University of Belfast 10 College Park Belfast BT7 1LP Tel : 02890976174 Email : mwp.reid at qub.ac.uk Sharepoint Training Portal ________________________________________ F -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com