[AccessD] Avoiding Duplicates on a Report

What do you mean by normalized?  The customer has the ability to
purchase up to 6 products on one invoice.  The table assigns the invoice
number and than records the products selected in the fields Product1
thru Product6.  The customer# is pulled from the customer table.

Mike Gowey  MCDST, A+, LME, NET+
Team Leader - East Region
Information Systems Unit

-----Original Message-----
From: Susan Harkins [mailto:ssharkins at bellsouth.net] 
Sent: Thursday, May 19, 2005 8:30 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Avoiding Duplicates on a Report



This makes me think your table's not normalized. Is this the case? 

Susan H. 

This don't work because the product I search for could be in any of 6
fields, Product1 thru Product6. 


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