Urgent. I have a DataSet with mult

[mondi]

Urgent.
I have a DataSet with multiple tables. The idea is this: In the first table I have the ID. The second table has the data field that I must display in the report and the ID. I have to select the ID in the first table and display the corresponding data field in the report from the second table.
If somebody could help me, I would be very grateful.

 

[jjlogan]

Generally, when you need to work with data from two or more table, you set up (design) a query and link the tables in the query. Or you can work directly in SQL and do same linking. Then, base you dataset or recordset on the query or sql statement.
Jeff

 

[mondi]

The tables are linked. The problem is that, by using the formula editor, I want to display in the report the field from the second table. I have an ID in the first table. In the second table I have to find a data field corresponding to this ID.