Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Create a Form with a P...
Finance | Project Operations, Human Resources, ...
Suggested answer

Create a Form with a Parent-Child Relation records

(1) ShareShare
ReportReport
Posted on by SGbron 157

Hello everyone

I want to create a form that brings back the child records of a parent record

To be more specific

I have three tables : A) ProdJournalBOM 
                                B)  LinkerTable
                                C)  MyBOMLinesTable


MyBOMLinesTable is a table that has the information of ProdJournalBOM summary. More specifically it creates a record with an index which
related with the number of Journals that belongs to a specific BOM.

the LinkerTable has been created with two fields. The recId of MyBOMLinesTable and the recid from ProdJournalBOM which is related.

Until this step everything works fine.

Now I want when I press a button from the form of MyBOMLinesTable, to see all lines in ProdJournalBOM that related with the specific line a have choose in my MyBOMLinesTable. 

I have tried some things without coding until now, only from the properties of the datasources.
The result I took, was to see in the new form only one record (from existing 5 for example). 

Does anybody know what can be wrong with this and how can this problem be solved?  

  



  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Create a Form with a Parent-Child Relation records

    Is the form you are using for ProdJournalBOM a customized one? In that case you should be able to add LinkerTable as the main datasource on the form.

    You are facing this issue because in your case, LinkerTable is the parent and ProdJournalBOM is the child datasource. Since ProdJournalBOM does not have a column with LinkerTable RecIds, the auto join won't work.

  • SGbron Profile Picture
    SGbron 157 on at
    RE: Create a Form with a Parent-Child Relation records

    Unfortunately this doesn't work...

    PS. By mistake I clicked in action and I reported  your post as abusive. Sorry!!!!

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Create a Form with a Parent-Child Relation records

    Hi,

    Can you try adding a relation on ProdJournalBOM to LinkerTable and try?

  • SGbron Profile Picture
    SGbron 157 on at
    RE: Create a Form with a Parent-Child Relation records

    Hello Gunjan

    thank you for your reply!!

    yes, you are correct.

    The datasource that i set on the menu item is the LinkerTable. But i get only one record. The first record or the last one depending the property of the datasource "StartPosition"..

  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Create a Form with a Parent-Child Relation records

    From what I gather from your description,

    1. The Linker table has an 1:n relation with the ProdJournalBOM.

    2. There is no direct relation between MyBOMLinesTable and ProdJournalBOM.

    If this is true, what data source has been mentioned for the menu item button opening the ProdJournalBOM form?

    It should be LinkerTable.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,280 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,038 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans