boris
Posts: 14
|
| Posted: 07/31/2006, 5:18 PM |
|
This is my dilema and i'm not sure how to resolve it. I've simplified the dilema for ease of understanding.
We have 2 MSSQL databases.One has a list of Countries and the other has a list of Clients.
Country DB structure is CountryID, CountryName
Clients DB structure is ClientName, CountryID
We have a form where the Clients fill out their details and select from a ListBox (bound to Integer in the other DB) their respective Country. OK, no problems with this bit.
Now we want to create a Grid which lists the ClientName with the Country Name (not the integer value) but can't seem to get the right answer.
What we want is to achieve is:-
A Company Name, USA
B Company Name, UK etc.
Instead the best we can get is:-
A Company Name, 13
B Company Name, 21 etc.
which is all from the one DB.
I know if we combined the 2 DB's into 1 we wouldn't have this issue but we don't want to do that.
Has anyone got a solution for this? Any help is appreciated.
Thanks in advance.
|
 |
 |
peterr
Posts: 5971
|
| Posted: 07/31/2006, 8:51 PM |
|
I recommend trying Google:
http://www.google.com/search?hl=en&q=query+multiple+sql+server+databases
http://groups.google.com/groups?q=query%20multiple%20sq...ver%20databases
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
boris
Posts: 14
|
| Posted: 07/31/2006, 9:13 PM |
|
Thanks Peter for a reply.
I've already been looking on Google as you had suggested but being a complete SQL novice it is all a steep learning curve for me.
I can see that you can join 2 tables together to create a View so i assume i use query that in CCS? I'll try and get my head around it again.
One thing i did try was to link both MSSQL DB's into an Access 2003 MDB and use that as the connection. It works great if i open Access directly but for some reason CCS dosn't see any of the tables in the Grid wizard . So i sort of gave up with that thought.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 07/31/2006, 9:46 PM |
|
You can probably create Views in MS SQL Server and then use those Views in CCS.
Regarding Access, I think that linked tables should work in CCS. At least I can see linked tables in CCS when connecting to MS Access via ODBC. It doesn't work for me only when connecting via JET.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
