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!

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

linking primary table field

Status
Not open for further replies.

jlr123

Technical User
Feb 24, 2014
117
US
Can't figure out join my link from primary table to another table. I want results from the primary table field (cust no) only to match the field cust no in my other table. no other customer no in results.
thanks for your assistance.
Table 1 - Field- Cust No
Table 2 - Field -Cust No
 
It should just be a inner join with a link type of '=' (i.e, default link for Crystal Reports).
 
I have tried that but I get too many customer number data results. I just want the data results from the customer no in the primary table.
Thanks,
 
Are you getting duplicated results? If so, there may be a second link that is necessary. Other you need to do some other filtering.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top