web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Related table not show...
Microsoft Dynamics AX (Archived)

Related table not showing up in report selection criteria '1:n' menu

(0) ShareShare
ReportReport
Posted on by Stuart Clouston 52

Hi All,

I have a created a custom table called CustMembershipTable.  The table contains a field named CustAccount based on the CustAccount EDT that relates it back to the CustTable.

My issue is that when I open a report dialog, click "Select" to customise the selection criteria, right click on the Customers table and choose 1:n to add my custom table, it's simply not there.  How do I get the new table to appear in this list?

Things I have tried:

- ensured that a relationship exists to CustTable by means of the EDT.

- created a manual relationship between the two tables from both the CustTable side and the CustMembershipTable side.  (CustMembershipTable.CustAccount == CustTable.AccountNum)

- ensured that the new table has a descriptive label: "Customer Membership Table"

- ensured that TableGroup property is set to "Group"

- searched this forum and the Internet for a solution to no avail.

I'm out of ideas and I'd be very grateful to anyone who can answer this one for me.

Thanks,

Stuart

*This post is locked for comments

  • Verified answer
    Mea_ Profile Picture
    Mea_ 60,286 on at

    Hi Stuart Clouston ,

    Did you try to build cross references ? As far as I remember AX use them to build this list so if you created new table\edt with relation you need to build  cross references,

  • Verified answer
    dynamics developer Profile Picture
    dynamics developer 2 on at

    And since the cross reference update is a time consuming process you might want to run the below job to update all the the cross references using batch job. (make sure not to shut down the server while it's processing and AOS is running)

    static void CrossRefUpdateBatch(Args _args)
{    
    xRefUpdateIL::updateAllXref(true, false, true);
    info("Done, cross reference update batch job created.");
}


  • Stuart Clouston Profile Picture
    Stuart Clouston 52 on at

    Hi Ievgen,

    That did the trick.  Thank you!

  • Stuart Clouston Profile Picture
    Stuart Clouston 52 on at

    Hi Haris,

    Thanks for that.  I tried it the manual way (Tools > Development Tools > Cross-reference > Periodic > Update) in my test environment and it was pretty quick (about one minute).  But I will test and use your script to automate the process for future.

    Thank you!

  • dynamics developer Profile Picture
    dynamics developer 2 on at

    I see, then you must have been updating cross references regularly or there is not a lot of customization yet.

  • Stuart Clouston Profile Picture
    Stuart Clouston 52 on at

    There's actually a fair bit of customisation, so I'm surprised I haven't come across this issue before.  Do cross-references get updated as part of a full application compilation?  (Administration > Periodic > Compile application)

  • dynamics developer Profile Picture
    dynamics developer 2 on at

    I am not sure about it but I don't think so.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the September Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Prashant Singh Profile Picture

Prashant Singh 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans