[AccessD] Sub Form

Dean dnod at aol.com
Wed Aug 24 18:43:51 CDT 2011


I have done it this way. You cannot edit directly but if you keep a field that tells you which table it comes from, you can edit and update behind the scenes in VBA. The user will never know the difference, it will appear as one table or list to them.

Regards, Dean


On Aug 24, 2011, at 7:40 PM, Stuart McLachlan wrote:

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





More information about the AccessD mailing list