Don
|
| Posted: 04/08/2002, 1:12 PM |
|
How can I display two different fields on a form when the info for the two fields is coming from a lookup table? That is, I have a form for one table, but I want the part that's visible on the screen (a select box in one case and a URL in another) to be from two fields in a different table. I know how to do it manually but how and where within CodeCharge?
|
|
|
 |
Andrew B
|
| Posted: 04/08/2002, 6:34 PM |
|
The info you gave is a little vague, but here are my suggestions :
If you are using SQL Server, create a view. In that view just use the + operator to concatenate string (ie. FirstName + ' ' + LastName). Beware, though. This will concatenate to a null if any of the fields is null. You can turn this off though, read the Books OnLine.
If you are using access, construct a query and call that. I think you use the & operate to concatenate strings in access SQL.
Either of these methods will work in a raw SQL query as well, but that means typing it by hand into codecharge's custom sql windows.
If you need any help, post yer email up here or just reply :)
|
|
|
|
Don
|
| Posted: 03/10/2003, 2:29 PM |
|
This worked. Thanks
|
|
|
|
|
