Lookup

[georgeong]

I'm converting my old Paradox 4 DOS program to Delphi. And looking for a counterpart feature of
Paradox in Delphi

I have 2 tables with their fields listed below:


Product table - ProdCode OrderLineItem table - OrderNo
Description ProdCode
Unit Unit
Price Price
Discount Discount

If you're familiar with Paradox, specifying the -

Valcheck Define TableLookup {Product} AllCorrespondingFields on the ProdCode field of
OrderLineItem table

When editing the OrderLineItem table will have all corresponding fields with the same name
from Product automatically fill just by entering right ProdCode.

How do I duplicate this feature

Thanks - George

 

[LucieLastic]

Is this what you want ?

Create 2 TQueries.

a) TQuery 1 will have 'Select * from OrderLineItem'.
b) Add a TDatasource for Query 1.

c) TQuery 2, add 'Select * from Product where ProdCode = rodCode'
d) In TQuery 2, set it's datasource property to point to your TDatasource(for TQuery1).

In effect, query2 is being fed by the current record from query1 where the ProdCode's match. nb, query2's rodCode must be the same name as is in the 'select' of Query1.

There are also Lookup fields you can add to a TQuery's Fields via the field editor and right button click 'Add new field'.

Am I on the right lines here ?

lou

 

[svanels]

There is a FAQ entitled How to use Database Look Up fields faq102-1212

Regards S. van Els
SAvanEls@cq-link.sr