Finance | Project Operations, Human Resources, ...

Auto save Lines data instead of doing manually Form save button on my custom form.

(1) Share

Report

Posted on by JJDunaid

222

I have two Data sources on form as / Line /and / Line Details/. The relation between them is on RECID of Table /Line/. The line table is used to store item information etc on my form.

I have an enum field in /line table/ with three elements for suppose, when I select 1st element three rows are added into /Line details / table and number of lines for other two elements. Code validation is performed on modified field() on my enum field. when I insert data into line and select one element from Enum I have to save the record from save button on form or /Ctrl s/.

After saving I have to change the enum element again as I have changed the enum element the lines associated with element are added into the /Line Detail / table.

I have tried linedetails_ds.refresh() , linedetails_ds.research(true) in my modifiedfield() method.

In simple the recId from lines table is not passing into line details table until I save the form or refresh it / is there any way through which I can do it without saving or refreshing the form.

All responses (6)

Answers (0)

André Arnaud de Cal... 295,992 Super User 2025 Season 1 on at

Like (0)

Report

Auto save Lines data instead of doing manually Form save button on my custom form.

Hi JJDunaid,

Apologies. The form name is EcoResProductDetailsExtended. The main data source is the table InventTable.
JJDunaid 222 on at

Like (0)

Report

Auto save Lines data instead of doing manually Form save button on my custom form.

GirishS,, Sir can you suggest me anything ?
JJDunaid 222 on at

Like (0)

Report

Auto save Lines data instead of doing manually Form save button on my custom form.

Hi GirishS,

Yes , I have passed rec id of "line" table to "line details" table on init value() of "Line Details" table.
GirishS 27,825 Moderator on at

Like (0)

Report

Auto save Lines data instead of doing manually Form save button on my custom form.

Hi Junaid,

While inserting, are you assigning the Line table RecId to LineDetails table?

Thanks,

Girish S.
JJDunaid 222 on at

Like (0)

Report

Auto save Lines data instead of doing manually Form save button on my custom form.

Hi Andre Arnaud de C... ,

I could not find any form named "Invent Table " in AOT. Can you plz elaborate more which form you are pointing on. so I can get help or refrence from there .
Suggested answer

André Arnaud de Cal... 295,992 Super User 2025 Season 1 on at

Like (0)

Report

Auto save Lines data instead of doing manually Form save button on my custom form.

Hi JJDunaid,

There is a solution for your current issue. Examples are available in the application. On the form InventTable, there are multiple data sources with a similar scenario. The ItemId field is then passed to the related data sources using the write() method. You don't need refresh or research commands.

Community site session details

Auto save Lines data instead of doing manually Form save button on my custom form.

Helpful resources

Quick Links

Ramesh Kumar – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

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

Featured topics

Product updates

Community site session details

Auto save Lines data instead of doing manually Form save button on my custom form.

Helpful resources

Quick Links

Ramesh Kumar – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates