Building master detail relationship

From: Oliver Tse (news_at_olivertse.com)
Date: 03/17/05 

Date: Thu, 17 Mar 2005 15:40:08 +0800

I have two ADOQuery.

query1 with datasource1 has fields:
  OEA01, .......

query2 has fields:
  OEB01, ......

where OEA01 = OEB01.

The SQL string in the query2 is:
  Select * from table2 where OEB01 = :OEA01

I set the datasouce property of 2nd query to datasource1. I open the 1st
query is OK. When I tried to open the 2nd query, a error message was showed
and the 2nd query could not be open.

Anybody can help me to solve this problem?

Thank you

Oliver Tse

Relevant Pages

  • Re: Select Top 5
    ... when looking at a record in query2 ... xbox Bill Gates $465.00 ... office software Bill Gates $200.00 ... The query that I ...
    (microsoft.public.access.queries)
  • Re: How do you pass parameters between queries in Microso
    ... It sounds like you might have one query that depends on the ... and two queries (QUERY1, QUERY2). ... user retrieves formatted records within a particular date range by ... QUERY1 references the text boxes in FORM1 where a data range is entered. ...
    (microsoft.public.access.queries)
  • Re: Extremely slow IN clause
    ... How much time it takes to run the Query2? ... time for each possible value of Query 1). ... the only way I could find to incorporate Query2 into Query1 is to use ... > returns over 4500 records in less than a second; adding the IN clause ...
    (microsoft.public.access.queries)
  • Re: Extremely slow IN clause
    ... means writing another query. ... > Query2 is a query object, ... > that speeds things up considerably. ... So it appears it's not the IN clause per se, ...
    (microsoft.public.access.queries)
  • Re: 1st, 2nd, 3rd, etc
    ... second highest 2nd ... I might make a query that groups on the score. ... add Query2 to the builder and link Score To ... A purely SQL query will run faster but requires a bit of SQL knowledge to write. ...
    (comp.databases.ms-access)