[AccessD] Sub Form

In this situation, I generally  use a separate subform for each table rather than trying to 
combine the data.   I would create an unbound master form and three bound subforms with 
hidden textboxes to provide the links..  You can make the three subforms Single or 
Continuous depending on the data you wany to show.

Assuming Table2  has a 2 field PK:

Subform1.RecordSource =  Table1

TetxBox1.Source  =  =frmSubForm1.PK


Subform2.RecordSource =  Table2
Subform2.ParentLink = TextBox1
Subform2.ChildLink = Table1FK

TetxBox2.Source  =  =frmSubForm2.PK1
TetxBox3.Source  =  =frmSubForm2.PK2


Subform3.RecordSource =  Table3
Subform3.ParentLink = TextBox2;TextBox3
Subform3.ChildLink = Table2FK1;Table2FK2

-- 
Stuart

On 24 Aug 2011 at 17:59, Martin Reid wrote:

> 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
>