Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Always keep edit record in related table

(1) ShareShare
ReportReport
Posted on by 187
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
  • Verified answer
    nbhatti2001 Profile Picture
    nbhatti2001 187 on at
    Always keep edit record in related table
    I have create the saperate form and it worked. Now I am able to edit record any time. 
  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 230,503 Most Valuable Professional on at
    Always keep edit record in related table
    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.
  • nbhatti2001 Profile Picture
    nbhatti2001 187 on at
    Always keep edit record in related table
    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. 
     
  • Martin Dráb Profile Picture
    Martin Dráb 230,503 Most Valuable Professional on at
    Always keep edit record in related table
    What is your version of AX?
     
    Isn't CarLoanRegInfo joined with CarLoanTable?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,431 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,503 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans