[AccessD] Back to Front

Martin Caro mcaro at bigpond.net.au
Fri Mar 4 15:01:51 CST 2005


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  



More information about the AccessD mailing list