how do i prevent a cartesion product in access 2007?

's Computer Specifications

I'm bringing 2 tables together and it is creating duplicate information when
there is only one record in one table and more than one record in the second
table. Can I use a coalesce or a union query in Access? Where can I go to
see examples?

's Computer Specifications

Link the matching fields together and right click on the line drawn between.
Select the option for the table you want all records from.
"LoyalT" <LoyalT @discussions.microsoft.com> wrote in message
news:46E1A527-BF43-4ACE-9055-(E-Mail Removed)...
> I'm bringing 2 tables together and it is creating duplicate information
> when
> there is only one record in one table and more than one record in the
> second
> table. Can I use a coalesce or a union query in Access? Where can I go to
> see examples?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I prevent others from editing my Access 2007 database?	jldube	Microsoft Access Getting Started	2	17th Feb 2010 07:35 PM
Prevent Access 2007 from starting setup	Jan Serpieters	Microsoft Access	2	25th Oct 2009 01:48 AM
Prevent windows installer when open access 2007	Jose	Microsoft Access Form Coding	5	20th Sep 2008 10:55 AM
How do I prevent deletion or changing of a record in Access 2007?	Aldric	Microsoft Access Database Table Design	2	1st Jul 2008 02:03 AM
Access 2007: how can I prevent duplicates in a combo box.	techman41973@yahoo.com	Microsoft Access	1	15th May 2008 10:22 AM