Hello Geoff.
>> I have a combo in a grid (work order items) and I want to display a list of people to allocate that work item to based on on a work category on the product record. Each line item can potentially have a different work category and so I need a list that is dynamic. <<
Merry Christmas!
The easiest way to do what you want is to set up a parameterized view to use as the RowSource of the combo and set up the combo with a RowSourceType of 6-Fields. Code like this in the GotFocus() of the combo:
LOCAL lcGridAlias, vp_cl_key
DODEFAULT()
WITH This
lcGridAlias = This..Parent.Parent.RecordSource
vp_cl_Key = &lcGridAlias..Cl_Key
REQUERY( 'lv_location' )
.Requery()
.Refresh()
ENDWITH
Nothing else should be required.