Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

record replication

Status
Not open for further replies.
leburg

leburg

Programmer
Feb 15, 2006
64
US
(crystal 8.5)

I have 2 tables, t1 and t2, linked up equal join. Thing is when I select using t1, there are 4 records, however when I place a field from t2 into the report, each record comes up 3 times, making it 12 records...not sure what is going on. I'd appreciate any help.

Many thanks in advance.
 
Sort by date Sort by votes
It just means there are three records in t2 for every one record in t1, i.e., a one-to-many situation. How you deal with this depends upon what you intend the report to do/show.

-LB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

inkbird01
  • Locked
  • Question
Filters > Record Selection for dates between
Replies
4
Views
355
pmax9999
pmax9999
socalvelo
  • Locked
  • Question
Limiting the number of records in groups and sub-reports 1
Replies
2
Views
195
socalvelo
socalvelo
Kofstar
  • Locked
  • Question
How to display only one field record horizontally in crystal report
Replies
4
Views
255
Kofstar
Kofstar
nerdygirlgear
  • Locked
  • Question
Limit sub report records to a time range on main report 1
Replies
1
Views
165
hilfy
hilfy
azeemkhn
  • Locked
  • Question
multip rows merging in in single record.
Replies
2
Views
109
azeemkhn
azeemkhn

Part and Inventory Search

Sponsor

Back
Top