Filter on Table in TableRelation on Request Form

Business Central/NAV Developers Forum
1

Hello,

I am developing a dataport to import journal lines from a text file. On the request form, I have at TextBox with a Source Expression called JournalType (code) and a table relation = “Gen. Journal Template”.Name WHERE (Type=FILTER(General))

My second TextBox has a table relation = “Gen. Journal Batch”.Name and a source expression called JournalName (code)

How do I filter the records in the “Gen. Journal Batch” (second TextBox) according to the value selected in the “Gen. Journal Template” (first TextBox) ?

Any help is much appreciated! [:)]

Thanks in advance!

2

Hi Petan,

You will need to add code in the onlookup trigger on the second textbox. Create a variable of datatype record for the general journal bach and filter it down to the variable by the template selected. Then call the lookup form in code. Look at form 7002 sales prices for an example.

Hope this helps

3

Thanks, DaveT!

That was what I needed.