Relationship troubles....LOL!!

  • Thread starter Thread starter JB_96RS
  • Start date Start date
J

JB_96RS

Howdy! Having some troubles with my relationships... and I am no
talking about my ex. Anyways, I am linking two tables (mor
afterwards, but starting off basic). Both tables contain a fiel
"Lot". And from the second table ("Box ID") I list the ID of the Bo
that the lot is in (the lots can be seperated into multiple Boxes).
The problem is: The qry lists out each item in the Lot for each Bo
ID. All I need is for it to show once. Is there a way to hide th
duplicates?


Thanks,

J
 
JB: In Help type "distinctrow" and read the results.
Depending on your query, you should use "distinct"
or "distinctrow" after "select" to eliminate the
duplicates.

GRayL
 
Back
Top