Always keep edit record in related table

(1) Share

Report

Posted on by nbhatti2001

222

Hi All,

I have custom tables CarLoanTable and CarLoanLines for my Car Loan Module. I have create relation and it is working fine. Then a new requirement arive, that we need car info like registration and model detail which will be editable all the time. Earlier I have block the editing after posting of record.

For new requirement I have create new table CarLoanRegInfo and create foreign key ParentRecId and relate it with CarLoanTable. Now the problem is when I am going to stop editing of CarLoanTable the table CarLoanRegInfo editing also going to stop.

I need to CarLoanRegInfo always editable, how I can do this, please help.

I am following the OOB form CustFreeInvoice and using the following line to enable or disable editing of CarLoanTable.

To On editing

SLD_CarLoanTable_ds.allowEdit(true);

To stop editing

SLD_CarLoanTable_ds.allowEdit(false);

Thanks

I have the same question (0)

All responses (4)

Answers (2)

Martin Dráb 238,828 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

What is your version of AX?

Isn't CarLoanRegInfo joined with CarLoanTable?

Was this reply helpful? Yes No
nbhatti2001 222 on at

Like (0)

Report
Copy link

Link copied!

I am using D365FO and Yes, I have join the tables and I have mention its join in question.

Here is the relation detail

Car Registration portong should be editable any time while the header should be non-editable. Non-editable working fine.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 238,828 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I'm sorry, but there no join is mentioned in your question. You mentioned a table relation, but it says nothing about your form data sources. Instead of being joined, they could be linked or independent.

What you see is the expected behavior if the data sources are joined. The best approach in your case may be to link the data sources instead of joining them. You can have a separate form for editing CarLoanRegInfo details.

Was this reply helpful? Yes No
Verified answer

nbhatti2001 222 on at

Like (0)

Report
Copy link

Link copied!

I have create the saperate form and it worked. Now I am able to edit record any time.

Was this reply helpful? Yes No