ayuda con una consulta

[karlaoax]

Hola narcisoplayero te pongo una seccion con instrucciones para que conozcas acercas del Master/Detail que estoy segura te funcionara mas adelante, espero que tu ingles ande bien

Difficulty Level: average Time Required: 10 minutes
Here's How:
1. Start Delphi and select File | New Application...

2. Select Data Access page on the Component palette. Place two TTable components on a form. Place two TDataSource components on a form.

3. Select Data Controls page on the Component palette. Place two TDbGrid components on a form.

4. Set the DatabaseName of the TTable components (Table1 and Table2) to the name of the database to access. Select DBDemos.

5. Set the TableName property to the name of the table in the database. Select customer.db for the master table: Table1.

6. Do the same with the child table. Select orders.db for the Table2.
7. Select the first TDataSource (DataSource1) component and set DataSet property to the name of the table component, that is: Table1.

8. Do the same with the second TDataSource (DataSource2) component and set DataSet property to the name of the table component, that is: Table2.

9. Select the first TDbGrid (DBGrid1) component and set the DataSource property to the name of the data source component, i.e. DataSource1. The same for, that is, TDbGrid2.DataSource:=DataSource2.

10. Set the MasterSource property of the Table2 component to the DataSource1.

11. Set the IndexFieldName property of the Table2 component to the CustNo.

12. Click the ellipsis button next to the MasterFields property of the Table2. This will invoke the Field Link Designer.

13. In the Detail Fields list the select CustNo, in the MasterFields list select CustNo. Click Add. Click Ok.

14. Set the Active property of both table components to True.

15. Browse through the records.


Tips:
The most important thing in master-detail relationship is the link between the tables. For each record in the master table, the form displays all corresponding records in the detail table.
Important detail table properties are: IndexFieldNames, MasterFields and MasterSource. For more info look in Delphi Help files.

Los puntos 12,13 y 14 son los mas importantes, te los marque en azul.

Karla