Alfred Trabulsi
|
| Posted: 11/01/2002, 4:19 PM |
|
Hello:
I'm designing an application in which there are 2 access data bases:
DataCatalogs and Invoices.
One of my forms "Invoices" has the field {carrier} and contains the
{carrier_id}; I need to display the carrier's name but this information is
on the "DataCatalogs" database.
I created two connections on my project, DataCatalogs, and Invoices.
How do I get the {carrier_name} from the other database from within CCS?
Thanx in advance
Alfred.
|
|
|
 |
Alexey Alexapolsky
|
| Posted: 11/04/2002, 5:31 AM |
|
In event you can look up value from another database via CCDlookUp function,
the function accepts connection as one of arguments.
--
Alex,
Support Engineer
CodeCharge Team
"Alfred Trabulsi" <atra@intelexis.com> wrote in message
news:apv5n6$ufc$1@news.codecharge.com...
> Hello:
> I'm designing an application in which there are 2 access data bases:
> DataCatalogs and Invoices.
>
> One of my forms "Invoices" has the field {carrier} and contains the
> {carrier_id}; I need to display the carrier's name but this information is
> on the "DataCatalogs" database.
>
> I created two connections on my project, DataCatalogs, and Invoices.
>
> How do I get the {carrier_name} from the other database from within CCS?
>
> Thanx in advance
> Alfred.
>
>
|
|
|
|
guest
|
| Posted: 11/04/2002, 7:43 AM |
|
If you are able to modify the access databases, set up linked tables in one
of the databases to point to the tables in the other database. (File->Get
External Data->Link tables). This will save you a lot of time and handcoding
all the logic to handle a second database.
"Alfred Trabulsi" <atra@intelexis.com> wrote in message
news:apv5n6$ufc$1@news.codecharge.com...
> Hello:
> I'm designing an application in which there are 2 access data bases:
> DataCatalogs and Invoices.
>
> One of my forms "Invoices" has the field {carrier} and contains the
> {carrier_id}; I need to display the carrier's name but this information is
> on the "DataCatalogs" database.
>
> I created two connections on my project, DataCatalogs, and Invoices.
>
> How do I get the {carrier_name} from the other database from within CCS?
>
> Thanx in advance
> Alfred.
>
>
|
|
|
|
Alfred Trabulsi
|
| Posted: 11/04/2002, 5:24 PM |
|
Hi, thanx for your reply.
I do have linked tables on my access database but all the linked tables do
not show up in CCS query builder hence, I can not use the Add Table command.
Am I missing something?
Thanx
Alfred
<dontspamme_dsafar@hotmail.com> wrote in message
news:aq64jn$1iq$1@news.codecharge.com...
> If you are able to modify the access databases, set up linked tables in
one
> of the databases to point to the tables in the other database. (File->Get
> External Data->Link tables). This will save you a lot of time and
handcoding
> all the logic to handle a second database.
>
> "Alfred Trabulsi" <atra@intelexis.com> wrote in message
>news:apv5n6$ufc$1@news.codecharge.com...
> > Hello:
> > I'm designing an application in which there are 2 access data bases:
> > DataCatalogs and Invoices.
> >
> > One of my forms "Invoices" has the field {carrier} and contains the
> > {carrier_id}; I need to display the carrier's name but this information
is
> > on the "DataCatalogs" database.
> >
> > I created two connections on my project, DataCatalogs, and Invoices.
> >
> > How do I get the {carrier_name} from the other database from within CCS?
> >
> > Thanx in advance
> > Alfred.
> >
> >
>
>
|
|
|
|
|
