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.

All responses (6)

Answers (0)

Sort by

Suggested answer

André Arnaud de Cal... 307,271 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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.
JJDunaid 226 on at

Like (0)

Report
Copy link

Link copied!

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 .
GirishS 27,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Junaid,

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

Thanks,

Girish S.
JJDunaid 226 on at

Like (0)

Report
Copy link

Link copied!

Hi GirishS,

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

Like (0)

Report
Copy link

Link copied!

GirishS,, Sir can you suggest me anything ?
André Arnaud de Cal... 307,271 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi JJDunaid,

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