🚀 go-pugleaf

Hi Mark,

I will test today..

Very thank�s Mark!


Mark Cashman <mcashman@temporaldoorway.com> escribi� en el mensaje de
noticias 3B297036.68B7A5B3@temporaldoorway.com...
> 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
> ------
>
>