🚀 go-pugleaf

Hi, Jaime!

You can either...

1) Use a lookup field on one TADOTable that refers to fields in another
TADOTable or
2) Use a TADOQuery with a SELECT command that joins the two underlying
database tables.

To create a lookup field, double-click on the TADOTable, right button on
the fields editor window that appears, pick "New Field" and then create
the lookup field; set the field in the current table which is to be used
as the key to the other table, set the other table, and set which field
in the other table is the key, and which field in the other table is to
be returned.

To create a SQL SELECT command to join the two tables, follow the
pattern...

SELECT * FROM sometable,othertable WHERE sometable.otherID =
othertable.ID

Note that the table names in this command are not the names of two
TADOTable components, but are the names of underlying database tables.

I hope this helps.

------
Mark Cashman (TeamB - C++ Builder), creator of The Temporal Doorway at
http://www.temporaldoorway.com
- Original digital art, writing, music and more -
C++ Builder / JBuilder Tips and The C++ Builder Programmer's Webring
(Join us!)
http://www.temporaldoorway.com/programming/index.htm
------