[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