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