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

226

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.

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

André Arnaud de Cal... 301,171 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
JJDunaid 226 on at

Like (0)

Report

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 .

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

Hi Junaid,

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

Thanks,

Girish S.

Was this reply helpful? Yes No
JJDunaid 226 on at

Like (0)

Report

Hi GirishS,

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

Was this reply helpful? Yes No
JJDunaid 226 on at

Like (0)

Report

GirishS,, Sir can you suggest me anything ?

Was this reply helpful? Yes No
André Arnaud de Cal... 301,171 Super User 2025 Season 2 on at

Like (0)

Report

Hi JJDunaid,

Apologies. The form name is EcoResProductDetailsExtended. The main data source is the table InventTable.

Was this reply helpful? Yes No

Join the conversation

Community site session details

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

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

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

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