Multiple Customer Names on one selection/record

[GodSend]

Perhaps this is a really easy queston, but one that I none the less can not find the answer for. Considering the following example tables :

Table Customer
ID
Name
Street
....

Table ProBill
Amount
sold_id (references ID in Customer table)
bill_to (references ID in Customer table)
ship_to (references ID in Customer table)
....


I would like to run a simple report that shows all the ProBill information for a user selectable date range. Everything works fine except for displaying the Customer Name from the ID table rather then the sold_to, bill_to, and ship_to from the ProBill table.

The problem I keep running into is how to show the following

Date | Customer name for sold_id | Customer name for bill_to

I can not seem to get Crystal reports 9 to realize which "CUSTOMER" I would like to display in which order because there is more then one Customer.NAME to be displayed per record (does this make any sense?

Thanks everyone in advance for any answers they can provide.

 

[synapsevampire]

Assuming that the sold_id, bill_to, ship_to can all be different.

Add the Customer table in 3 times, each linking to it's appropriate field.

-k

 

[GodSend]

Worked, thanks a ton!