How to filter form

Business Central/NAV Developers Forum
1

Hi all, I have problem about filtering. does anyone know how to filtering a form with form.runmodal command?, for example, my customer is Superman, I chose it on header form, and I want on line form, when I look up, there is only Superman…okay thanks

2

if have done it like: MiPa.SETRANGE(MiPa.Rufnummer, “A-Nummer”); MiPa.SETRANGE(MiPa.Debitor, Kontonr); MiPa.SETRANGE(MiPa.Vertrag, VertragsNr); MiPa.SETRANGE(MiPa.Position, PositionsNr); CLEAR(MiPaForm); MiPaForm.SETTABLEVIEW(MiPa); MiPaForm.LOOKUPMODE(TRUE); MiPaForm.RUNMODAL; where “MiPa” is the source table and MiPaForm is the form i view the table

3

Thank you. But where should I place it on trigger? (OnLookup?)

4

do you mean that I must filter the table first? What are these? MiPa.SETRANGE(MiPa.Rufnummer, “A-Nummer”); MiPa.SETRANGE(MiPa.Debitor, Kontonr); MiPa.SETRANGE(MiPa.Vertrag, VertragsNr); MiPa.SETRANGE(MiPa.Position, PositionsNr); thank you very much

5

Hi… Stefan… it’s work!, but…:frowning: when the form is open, I can’t pick it to the main form (it can’t embed to main form). what should I do?

6

I think you should change de LookupMode property on the form to ‘Yes’ (i.e. the form from which you want to select an item). When you have changed that you will see the OK button on the form. Herman Veerkamp