It allows me to search all the fields in the main table but NOT the related table field.
In the example, I can't search for "State name"
Thanks,
- Code: Select all Expand view
#include "fivewin.ch"
REQUEST DBFCDX
//----------------------------------------------------------------------------//
function Main()
local oDlg, oBrw
*SetGetColorFocus()
FERASE( "STATES.CDX" )
Use STATES alias "states" NEW exclusive VIA "DBFCDX"
FW_CdxCreate()
Set order to TAG CODE
go top
FERASE( "CUSTOMER.CDX" )
Use CUSTOMER alias "customer" NEW exclusive VIA "DBFCDX"
FW_CdxCreate()
go top
SET RELATION to field->state INTO states
Define Dialog oDlg size 1000,600 PIXEL TRUEPIXEL
@ 10,20 XBROWSE oBrw SIZE -20,-20 PIXEL OF oDlg ;
Columns "FIRST","LAST","CITY","STATE","states->name";
Headers "First","Last","City","State Code","State Name";
DATASOURCE "customer" ;
AUTOCOLS AUTOSORT CELL LINES NOBORDER
WITH OBJECT oBrw
:nMarqueeStyle := MARQSTYLE_HIGHLROW
:lSeekBar:= .T.
:lIncrFilter := .F.
:CreateFromCode()
END
Activate dialog oDlg centered
return nil
[img]
[/img]