[AccessD] Sub Form

Sorry, Stuart, I beg to differ here.  We really don't know, in the case of 
Martin's database, without some more details of the data structure.  But 
there are many scenarios other that what you described where a query will be 
undateable.  I frequently (and I assume you do too) have editable forms 
based on multi-table queries.

Regards
Steve

-----Original Message----- 
From: Stuart McLachlan
Sent: Thursday, August 25, 2011 1:01 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Sub Form

It would be updateable only if there is a one to one relationship between 
tables 2 and 3 and
you include all PKs fields from both tables in the query.

-- 
Stuart

On 25 Aug 2011 at 12:47, Steve Schapel wrote:

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