Hi Viv. Thanks for replying

Where are you obtaining the grid data from. Can't you just pull in the value via SQL ?

The 'Main' table will be passed in using Select statement , but I dont want to particulalry pass ' All' the related tables in,as depending on the installation, only very few of the related fields would ever be required. In VFP, I had these extra looked up fields data driven using a IIF(seek)

Say my main table is a Customer Table, but there could be losts of related tables with 'Lots' of data (e.g. Sales By Week By Customer could have 52 fields for each customer, Busdget by week by customer could have another 52, Units by week by cusotmer could have another 52 etc). On any one site, I might ever only need say week 1 sales for the sake of argument, and I dont want to have to pull 150 fields across.
I know the 'Disconnected' methodology in Dot Net probably makes this near impossible, but I live in hope !!

regards,
Gerard



>>In VFP using a Browse command, I'd have code like:
>>Brow fields a,b,c,d=iif(seek(MYCODE,'CUS','CUS_NDX'),Cus.Name,' ')
>> field D being a very handy way to do a lookup on another table
>>
>>In the .net world, using a grid, is there any equivalent, without doing a whole pile of selects out from another lookup table ?
>>For instance, is there a way to imbed into a Grid Field some sort of a Lookup function ?
>
>Where are you obtaining the grid data from. Can't you just pull in the value via SQL ?