Thanks David. I will have a look if a master-detail will solve my problem.
I thought the benifit (and speed) of a relational database would be larger,
but if I have to locate the record within a second table myself, what is the
benefit of a relational database?
regards
________________________________
Slide scanning / dia's scannen
vanaf / from
E0,08c
www.scancare.nl
________________________________
________________________________
From: David Smith <[email protected]>
To: [email protected]
Sent: Wed, January 13, 2010 11:22:31 PM
Subject: Re: [delphi-en] ADO: using the relations between access tables in
DataAware components
What is the relationship between the tables and how is it established? If
within Access, it probably won't propagate to the controls. I'm not that
familiar with ADO datasets, is there a MasterSource property of the TADOTable
component? If so, you should establish the (presumably Master/Detail)
relationship there. If not, you can always use the OnDataChange to set/reset a
filter condition. Locate() won't work because it will only find one record
(assuming it's a Master/Detail relationship) .
To load the image, use the OnDataChange event of the associated TDatasource.
Dave
--- On Wed, 1/13/10, Andries Bos <andries...@yahoo. com> wrote:
From: Andries Bos <andries...@yahoo. com>
Subject: [delphi-en] ADO: using the relations between access tables in
DataAware components
To: "delphi advanced group" <delphi...@yahoogrou ps.com>
Date: Wednesday, January 13, 2010, 1:43 PM
I have a form that contains different DBedit controls.
The primary information comes from one table. Some of the field has been
connected within Access to a field within a second table.
The first table contains personal information; the second the detailed company
information.
I would like that some DBedit controls that are connected to this second table
to be updated also when I navigate through the records in the first table.
Do I have to to a search via a 'locate' command to get this working?
I thought that, because of this relation between the field, there could be a
'shortcut' ; this should be the main advantage of these relations between the
different tables in the first place.
Also, I use the onchange event to trigger the loading an image (from a blob
field). Is this the correct event to connect to?
Regards
____________ _________ _________ __
Slide scanning / dia's scannen
vanaf / from
E0,08c
www.scancare. nl
____________ _________ _________ __
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
