>I guess I'm a little confused as to what you're tyring to acomplish here. Are you using one of his PickListForm's gizmos? If you are, than in the CreateIndexTags() method of the grid you can put something like:
>
>select sitems_lookup
>if .f.
> *
> * index tags can be created explicitly referencing
> * the tag name in THIS.iaColumnInfo[xx,3]
> *
> index on InvNum tag (THIS.iaColumnInfo[1,3])
> index on Descrip tag Descrip
> index on sitems_pk tag sitems_pk
>endif
>*
>* or index tags can be created by indirectly
>* referencing the tag name in THIS.iaColumnInfo[xx3]
>*
>index on InvNum tag (THIS.iaColumnInfo[1,3])
>index on Descrip tag (This.iaColumnInfo[2,3])
>index on sitems_pk tag (This.iaColumnInfo[3,3])
>
>
>Then in the SetIndexTagInfo() method of the same grid put something like:
>THIS.iaColumnInfo[1,3] = "InvNum"
>THIS.iaColumnInfo[2,3] = "Descrip"
>THIS.iaColumnInfo[3,3] = 'stiems_pk'
>
>---> >VFP 4.0 - VFP 5.0
>I'm assuming you mean VMP4 and VFP5.
>1) Are you one of the beta testers for VMP4?
>2) You should be doing some serious thinking about using VFP6 - VMP4 likes it much better.
>
>
>
Yes we have found the lost version of FoxPro VFP 4.0. That's correct. VMP 4.0. And we are beta-testing. Although after being bitten by a number of VFP 6.0 bugs we have decided to stay with VFP 5.0 until a stabler version comes a long.

Now here's what the LOOKUP function looks like.

LOOKUP( CompanyMstr.cCompany, CompanyCont.iCompanyID, CompanyMstr.iCompanyID, "Primary" )

We have placed this in the control source to retrieve the company name but at the same time allows us to prevent de-normalization ( another possible solotuion to this problem ). But we are actually using tables not views. Are you suggesting temporarily adding the above index to a table?