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