Jeremy
|
| Posted: 09/16/2002, 12:48 PM |
|
Hey all, I am using ASP/access 2k and CCS. I have two databases, one with a grid I am showing on one page, and the other database has the user information in it, like the security etc.
My question is, on the first database, I have stored the UserID in a record, but when I make a grid, I'd like to show the users "login", not the Numeric value. To do this I would have to lookup to the "users" database and match the ID. Is there a way to do this? I can do it if I'm using the same database for both tables, but I haven't found out how in CCS to lookup from one db to another to find the value of a field. Any help appreciated.
Jeremy
|
|
|
 |
Jeremy
|
| Posted: 09/17/2002, 9:24 AM |
|
Nicole maybe?
|
|
|
|
Nicole
|
| Posted: 09/18/2002, 2:47 AM |
|
Jeremy,
once the form you've working with is using one db connection, in order to retrieve values from another db, you should create new connection object, open it, perform look up operation and then close it.
Note, that both connection should exist in the project.
|
|
|
|
|
