[AccessD] Sub Form

Thinking about it a bit more, you are correct.  The "one to one"  is not critical. to 
"updateablility".

-- 
Stuart

On 25 Aug 2011 at 13:21, Steve Schapel wrote:

> 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 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>