Re: Master / Detail Tables
From: Bill Todd (no_at_no.com)
Date: 09/21/04
- Next message: Mike Shkolnik: "Re: Blob problem..."
- Previous message: Lourenço de Paula: "Blob problem..."
- In reply to: Sam G.: "Master / Detail Tables"
- Next in thread: Sam G.: "Re: Master / Detail Tables"
- Reply: Sam G.: "Re: Master / Detail Tables"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: 21 Sep 2004 06:36:10 -0700
Set the DataSource property of the detail ADOQuery to the master's
DataSource. Make sure that the foreign key parameter in the detail
SELECT statement's WHERE clause has the same name as the primary key
field in the master. When you do this the detail query will be executed
automatically each time you change master records.
-- Bill (TeamB) TeamB cannot answer questions received via email
- Next message: Mike Shkolnik: "Re: Blob problem..."
- Previous message: Lourenço de Paula: "Blob problem..."
- In reply to: Sam G.: "Master / Detail Tables"
- Next in thread: Sam G.: "Re: Master / Detail Tables"
- Reply: Sam G.: "Re: Master / Detail Tables"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
