How to set defaul value on FormGrid from Header Tab

(0) Share

Report

Posted on by sandipdjadhav

18,306

Hello Experts,

Happy New Year!

I have two table : 1 WorkOrderHeaderTable 2. WorkOrderDetailsTable.

Used Detailed Transaction FormPattern to design.

On DetailGrid , I want to set primary field value (WorkOrderNo) when Add Button click. How to do? I tried used "initvalue" method on WorkOrderDetailsTable but no luck.

Any exmaple of code will be highly appreciated.

Thanks much
Sandip

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

WillWU 22,361 on at

Like (1)

Report
Hi Sandip,

You could copy the onclick eventhandler of that Add command button and write your own logic to set the value.

[FormControlEventHandler(formControlStr(SalesEditLines, AddHeaderButton), FormControlEventType::Clicked)] public static void AddHeaderButton_OnClicked(FormControl sender, FormControlEventArgs e) { Args args = new Args(); FormCommandButtonControl callerButton = sender as FormCommandButtonControl; //Retrieves the button that we're reacting to FormRun form = callerButton.formRun(); //Gets the running SalesEditLines form FormDataSource salesParmTable_ds = form.dataSource(formDataSourceStr(SalesEditLines, SalesParmTable)) as FormDataSource; SalesParmTable salesParmTable = salesParmTable_ds.cursor(); SalesTable salesTable=salesParmTable.salesTable(); //Any Action... }

Was this reply helpful? Yes No
Suggested answer

sandipdjadhav 18,306 on at

Like (0)

Report

Hello Will,

Much appreciated for you reply. I did it with FormDataSource level InitValue. Below is code-

[DataSource]

class WorkDetailsTable

{

/// <summary>

/// Next routine will bring default value on WorkOrderDetail Table WorkOrder#

/// </summary>

public void initValue()

{

super();

WorkOrderTable wrkOrdHdrTbl =WorkOrderTable_ds.cursor();

WorkDetailsTable.WorkOrderNo = wrkOrdHdrTbl.WorkOrderNo;

}

}

Was this reply helpful? Yes No
Verified answer

Pete Alberts 3,542 on at

Like (1)

Report

Hi Sandip

Did you specify the "Join source" property on the WorkOrderDetailsTable DS?

If you created a relation on the WorkOrderDetailsTable (FK WorkOrderDetailsTable.WorkOrderNo == WorkOrderHeaderTable.WorkOrderNo) and you set the mentioned property on the DS then you won't need to write any code.

Your code is correct. Something is overring it, or WorkOrderTable.WorkOrderNo is blank. Debugging will shed some light on that. But I'd recommend you stay with relations and properties (it's counter productive to write code for something that is already automated by MS kernel).

Was this reply helpful? Yes No
sandipdjadhav 18,306 on at

Like (1)

Report

Hello Pete,

Much appreciated for your replied. You are 100% correct. I have just tested solution and it works. No code is rquired.

Thanks much
Sandip

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to set defaul value on FormGrid from Header Tab

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

How to set defaul value on FormGrid from Header Tab

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates