Queries dependent on results from other datasets.

Hi,

I need data from two datasources. From the first datasource a get only one row. Then I need to use one of the values in this row to filter the next query. I couldn't make it to work. Is it possible? Suggestions on how to do this?

Tomsi

One possible solution is to create internal parameter that will take default value from 1st data source.

When you can use this parameter in the second data set.

Queries

Hi,
how can I create a Form with a Datasource of two tables.
Regards
cucmejc
| From: <cucmejc@.yahoo.com>
| Subject: Queries
| Date: Sun, 17 Oct 2004 01:59:51 +0200
| Lines: 10
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
| X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
| Message-ID: <e6qZkt9sEHA.1308@.tk2msftngp13.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.jdbcdriver
| NNTP-Posting-Host: pd9e9f165.dip.t-dialin.net 217.233.241.101
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftn gp13.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.jdbcdriver:6350
| X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver
|
| Hi,
|
| how can I create a Form with a Datasource of two tables.
|
| Regards
| cucmejc
|
|
|
|
|
Hello,
Can you be more clear on what you are requesting?
Carb Simien, MCSE MCDBA MCAD
Microsoft Developer Support - Web Data
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.