Master:
           Transaction # (key)
           ...

Child:
           Transaction # (key)
           Item #
           ...

I want to line the 2 using "transaction #", and order the child table
by "trans # + item #" (it's already indexed). I'd changed the
MasterSources
and MasterFields properties of the child without success. I'd already
reported here that I'd got the "Field index out of range" error from
BDE. One nice guy told me to use the filtering method, but I'd found
this too troublesome under my case, which is quite complicated. Is there
some way to utilize Delphi's master-detail relation under my case?

Gary Tse.

+---------------------------------------------------------------------
|
| Q: Who's the guy that sold you something for plenty of bucks,
|    but'll tell you "Wow, ok, it's our *unique* feature (set).",
|    after the beast'd killed all what you have done this morning?
|
+---------------------------------------------------------------------

SELECT * FROM Child WHERE TransactionNo=:TransactionNo ORDER BY ItemNo

If you want to have RequestLive=TRUE then you need an additional
maintained index on ItemNo. Connect Query.Datasource to your master
tables datasource as usual to establish the master-detail relation
(in this case master=TTable detail=TQuery). Should work (at least it
works here ... I just tested a sample, since I usually don't use DBF).