EIP - Help needed to prime a key for lookup

[rleiman]

Hi Everyone,

I am using EIP in a browse that has 2 lookup fields, both set up through the Column Specific field properties. The first one does a lookup to a single field key and that works fine. This field is called SkuCagetory.

The other field SkuNumber does a lookup on a multi-field key and does not seem to work. It called the lookup procedure even though I entered a value that was really in the lookup table. I tried to prime the first part of the key using the More Field Assignments button in the Lookup Options window.

I also placed this code in the EIP Manager Take Accepted embed just to make sure the first part of the key was primed but I seem to be missing something here.

INV:SkuCategory = Queue:Browse.SalDet:SkuCategory

message('category: ' & INV:SkuCategory)

Here's the strange part. After the lookup procedure is called and I selected something from it, I could place valid values in the Sku Number field and the lookup works. I also tried an invalid value to make sure the lookup procedure got called and it did as expected.

Can you tell me why it fails the first time when I enter a valid value?

Thanks
Emad

 

[ShankarJ]

Hi Emad,

I don't do EIP much but maybe the issue is that the lookup uses the column value from the record buffer which is not updated from the Queue column until the update is done. I think this was reported as a bug/shortcoming and have no idea whwther it was resolved.

Regards

 

[rleiman]

Hi ShankarJ,

Thanks for responding.

I think the person I am writing the app for will allow me to combine the multi-field key as a single column in the table so the program will just do a single key field lookup.

Truly,
Emad