Refrence Number tied to Employee Name

[lbizzell]

Sorry if this is a stupid question, but I’m new to Crystal and it just hasn’t cliked yet… I’ve got crystal 9 and SQL

Here’s the deal: I’ve got three tables: order with the slsman number, slsman with the slsman number and reference number and employee with the reference number and name. I’ve created a link in database expert from order.slsman to table.slsman and slsman.ref_num to employy.Emp_num.

How do I display the Name rather than the Emp_num? I’m sure it’s a simple formula, but like I’ve said – it just hasn’t clicked for me yet.

Example:
Table Order
Slsman

Table slsman
slsman
Ref_num


Table employee
Emp_num Name
1 Coffee, Joe
2 Smith, Bill
3 Runion, Carol



Thanks-
Laurie

 

[synapsevampire]

I think you mean:

order.slsman to slsman.slsman and slsman.ref_num to employy.Emp_num

Are you sure that there isn't a slsman.emp_num?

If so, then placing the employy.name field should work.

Your question has nothing to do with Crystal, it is a database issue which means that you must learn how your database works, I'd check with your dba if possible.

-k

 

[lbizzell]

Thanks- I'll do that.
Laurie