David M
|
| Posted: 04/05/2003, 11:25 AM |
|
I have page(s) that I have created that retrieve purchase order data from a database based on a query. It includes first and last name, purchase date etc. Associated with the returned results is an ID (called partner_id) of the person who has made the sale. So when the grid displays the records of sales, it just shows the ID (partner_id) number of the person who has made the sale. Every ID has a corresponding username, password, first name and last name, etc. What I want to do is when the purchase records diplay, instead of showing the ID (partner_id) of the person who has made the sale, I want to do some kind of lookup to take the partner ID and match it up to the user ID (which have the same the ID number but different fields for storing) to find that persons first and last name and then display first and last name instead of the ID. I'm using ASP and CCS 1.0.7
I really need to solve this problem asap.
|
|
|
 |
Steven
|
| Posted: 04/05/2003, 12:55 PM |
|
if the peron who keys in the order is the person who makes the sale, why not save the user_id through use of the session UserID into the sale records, then later you can use a lookup from that user_id against the firstname , lastnae for any later uses?
Steven
|
|
|
|
|
