[AccessD] Sub Form

Ah-ha, you are not talking about  three level structure , you mean two children of the same 
parent table.  You can't edit a Union query.   

-- 
Stuart

On 24 Aug 2011 at 18:47, William Benson (VBACreations. wrote:

> True. Best.
> 
> But to accomplish the need, if the tables have the same fields (or can
> be coerced in such a way that you can query from them the same
> required data in the same order) I would make a single form use a
> recordsource that is a union query like
> 
> Select "1" as MySource, Fld1, Fld2, Fld3 from Tbl1
> Union all
> Select "2" as MySource, Fld1, Fld2, Fld3 from Tbl2
> 
> You can order by Fld1, MySource (assuming Fld1 is the right index - or
> create another, which is common to both tables, using some other
> interrelated queries)
> 
> If you display this in DS view, the each pair of records should show
> one source atop the other. Gets dicey when one table has a certain
> value for Fld1 and the other does not. Might want to find a way to
> insert null records through additional query steps.
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky
> Smolin Sent: Wednesday, August 24, 2011 6:35 PM To: 'Access Developers
> discussion and problem solving' Subject: Re: [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
> 
> -- 
> 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
>