Set Filter for popup form

Soloper · 2010-01-11

I create a new table and a new form based on this new table.

In sales order form I run this form. But I want to filter the new table (form) with the order number which is currently open in the screen.

How can I do that?

I put a button on sales order form and added the following code in OnPush trigger but doesnt work.

recNewTable.RESET;
recNewTable.SETCURRENTKEY("OrderNo","Line");
recNewTable.SETRANGE("OrderNo","No.");

FORM.RUNMODAL(50007,recNewTable);

lvanvugt · 2010-01-11

Why write code and not use the properties of the button?

Like:

Action RunObject RunFormView RunFormLink RunFormLinkType
Use for the Customer Card as your example and how the Ledger Entries menu item has been setup.

matttrax · 2010-01-11

You should definitely use the properties on the button in this case.

Incidentally, if you did it the way you were doing it, with code, you have to retrieve the record from the database first. That means GET or FIND.

Soloper · 2010-01-11

lvanvugt wrote:

Why write code and not use the properties of the button?

Like:
Action RunObject RunFormView RunFormLink RunFormLinkType

Use for the Customer Card as your example and how the Ledger Entries menu item has been setup.

Thanks, works.

Can you explain more about RunFormLinkType?

lvanvugt · 2010-01-11

I can, but read this first: RunFormLinkType.

If you want more explanation, just ask.

Set Filter for popup form

Answers

Categories