Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Unable to View details...
Microsoft Dynamics AX (Archived)

Unable to View details, no form exists for table ' Table Name'

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I added a new StringEdit control --Sales Channel on SalesTable form.  See following screenshot. When I right click on it then click View Detail. I got this error message :  Unable to View details, no form exists for table 'SalesChannelTable'

One of the suggested solution is to  change the SalesChannelTable property EDT Relation to Yes . I tried it. It didn't fix the problem instead of it changes the control from dropdown to text.  Any idea how to fix it?

Here are the steps that I did to create this Sales Channel control on the SalesTable form:

1. Create a table SalesChannelTable in AOT  with 2 fields (SalesChannelId, Name) 

2. Add a Primary index on SaleChannelId

3.Create a new field SalesChannelId in SalesTable

4. Add a new relation in SalesTable (SalesTable.SalesChannelId=SalesChannelTable.salesChannelId)

5. drag the SalesChannelId from SalesTable > DataSource to the SalesTable form[TabPage:HeaderView ]>[TabPage:TabHeaderSetup] 

I'm not sure what I have missed to cause 'Unable to View details, no form exists for table 'SalesChannelTable'.

Any help would appreciated. I have stuck on this one for couple of days. 

Thanks

Anna

*This post is locked for comments

  • Verified answer
    Denis Macchinetti Profile Picture
    Denis Macchinetti 16,444 on at
    RE: Unable to View details, no form exists for table ' Table Name'

    Hi Anna

    Glad to hear.

    If the replies helped you, please tick the answers as verified.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Unable to View details, no form exists for table ' Table Name'

    Thanks for the detailed explanation and instruction  Chris and Denis! It worked!

    Really appreciate your help

    Anna

  • Suggested answer
    cpironmo Profile Picture
    cpironmo on at
    RE: Unable to View details, no form exists for table ' Table Name'

    OK so this isn't simply a case of the system building a form for your Sales Channel table ad-hoc, this needs to be created and the link built between this form and the EDT behind the SalesChannelId fields.

    These 'View Details' links are based upon relations on table or on migrated (from previous AX versions) EDT's for bound controls such as your example.

    You will need to:

    Create the relation on the table (done as per your description), create a form for the table and a display menu item for this form.

    This menu item needs to have the same name as the table otherwise you will need to set the FormRef property on the table to specify the display menu item with a different name.

    Finally make sure to incorporate security around this menu item so that the required users with correct roles/duties/privileges can view it.

    I believe that should then have the desired effect. Let me know if not and I will double check I have described that correctly and possibly troubleshoot any differences.

  • Suggested answer
    Denis Macchinetti Profile Picture
    Denis Macchinetti 16,444 on at
    RE: Unable to View details, no form exists for table ' Table Name'

    Hi Anna

    As per my understanding, you have :

    1- Create a Simple List form for the SalesChannelTable Table

    2- Create a menuitem linked to the form created to the point 1

    3- Set the FormRef table property to the menuitem created to the point 2

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans