Drilldown with field filter

bbass

Hi there,

I have 3 customer-specific drilldown fields on the Item Card. The fields operate like a structure. If you choose a value out of the first drilldown field and then you want to fill in the second drilldown field, you only may view the records that have the same value as the one of the first drilldown field.

- the table/form that's behind the first drilldown field has the following
key: Itemgroup
- the table/form that's behind the second drilldown field has the following
keys: Itemgroup
Itemsubgroup

Any idea to pass the value (Itemgroup), that is selected by the customer out of the first drilldown field, as a filterfield on Itemgroup when opening the drilldown of the second field?

Thanks in advance!

oleschjoeth

On your form, you can programe the trigger OnLookUp for each field instead of using the direct field property. Catch the value of the first lookup field and use it in the OnLookUp for your next field and so on. Actually I think there is an example in HowTo's here on mibuso.com

Best regards,
Ole

RobertMo

First of all - as I understand - it's not drilldown, but lookup feature.
If this is true, you can achieve this by setting proper table relations on fileds:

I use 3 levels of grouping and I used existing fileds:
1. "Inventory Posting Group"
with table relation:
"Inventory Posting Group"

2. "Item Category Code"
with table relation:
"Item Category".Code WHERE (Def. Inventory Posting Group=FIELD(Inventory Posting Group))

3. "Product Group Code"
with table relation:
"Product Group".Code WHERE (Item Category Code=FIELD(Item Category Code))