Duplicate records

[rccline]

I have a form based on qryLeases. For each LeaseID there is just one record. Only one record (Lease) shows in the query when I run the query.

I linked as subform fsubTract to the form which has multiple tracts for each LeaseID. The form and subform are linked by LeaseID.

I want the tracts to show in the subform as a datasheet. This works.
However, shown on the form are duplicate records showing for each instance of the tract linked to the lease.

I want to show One lease with all of its tracts displaying in the subfrmTracts.

How can I fix this error?

Thanks.

Robert

 

[HarleyQuinn]

Without seeing your query it's a tough guess, but I'd look at the DISTINCT keyword.

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[TheAceMan1]

How are ya rccline . . .

You appear to have an [blue]Relational Table[/blue] problem!

I [blue]suggest[/blue] you ease on over to forum700. The guru's here can get you on your way!

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886