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 <[email protected]> wrote: From: Andries Bos <[email protected]> Subject: [delphi-en] ADO: using the relations between access tables in DataAware components To: "delphi advanced group" <[email protected]> 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]
