[AccessD] Back to Front

try this, not tested, just off the top of my head...

SELECT
HotelName
FROM
OWNERS
JOIN HOTELS
ON OWNERS.HotelID = HOTELS.HotelID
WHERE
OWNERS.OwnerID = <<value Here>>

Jeffrey F. Demulling
Project Manager
U.S. Bank Corporate Trust Services
60 Livingston Avenue
EP-MN-WS3C
St. Paul, MN  55107-2292
Ph: 651-495-3925
Fax: 651-495-8103
email: jeffrey.demulling at usbank.com


                                                                           
             "Martin Caro"                                                 
             <mcaro at bigpond.ne                                             
             t.au>                                                      To 
             Sent by:                  "Access Developers discussion and   
             accessd-bounces at d         problem solving"                    
             atabaseadvisors.c         <accessd at databaseadvisors.com>      
             om                                                         cc 
                                                                           
                                                                   Subject 
             03/04/2005 03:01          [AccessD] Back to Front             
             PM                                                            
                                                                           
                                                                           
             Please respond to                                             
                  "Access                                                  
                Developers                                                 
              discussion and                                               
             problem solving"                                              
             <accessd at database                                             
               advisors.com>                                               
                                                                           
                                                                           




Hi folks
What's the simplest way to do the following...
I have a table of hotels 1:M with a table of owners. (HotelID is my
primary/foreign key)
I want to select an owner from the owner table and for as many times as
that owner appears in the child table, list (in a subform), the related
hotels in the parent table.
I'm OK with the mechanics its just that it's back to front from normal and
it's the wrong end of the week (recursion?).

Ta
Martin
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




------------------------------------------------------------------------------
Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation.
==============================================================================