Hello
I have a simple Access 2003 database with 4 tables in it. Three of them ('distributor', 'category' & 'manufacturer') are related to the other ('linkage') by one to many relationships based on the primary keys.
The theory is that a distributor supplies certain categories of products and said products are supplied by a variety of manufacturers. When all of that info is pulled together a row is created in 'linkage'.
I'm trying to retrieve rows from 'distributor' that are not yet related to 'linkage'. In other words, no categories/manufacturers have been associated with a distributor yet. Making sense ?????
My problem is that I can't manage to get the rows out of 'distributor' which have no rows in 'linkage' yet.
I now have bald patches on my scalp where I've been pulling hair out. I've tried all manner of joins but I'm obviously doing something wrong - HELP please. I'm running out of hair.
Thanks in advance
Keith
In case I forget to say 'Thank you' I'll say it now - thank you for your help !!!
I have a simple Access 2003 database with 4 tables in it. Three of them ('distributor', 'category' & 'manufacturer') are related to the other ('linkage') by one to many relationships based on the primary keys.
The theory is that a distributor supplies certain categories of products and said products are supplied by a variety of manufacturers. When all of that info is pulled together a row is created in 'linkage'.
I'm trying to retrieve rows from 'distributor' that are not yet related to 'linkage'. In other words, no categories/manufacturers have been associated with a distributor yet. Making sense ?????
My problem is that I can't manage to get the rows out of 'distributor' which have no rows in 'linkage' yet.
I now have bald patches on my scalp where I've been pulling hair out. I've tried all manner of joins but I'm obviously doing something wrong - HELP please. I'm running out of hair.
Thanks in advance
Keith
In case I forget to say 'Thank you' I'll say it now - thank you for your help !!!