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

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Denis Macchinetti 16,444 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

cpironmo 2 on at

Like (4)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Really appreciate your help

Anna

Was this reply helpful? Yes No
Verified answer

Denis Macchinetti 16,444 on at

Like (0)

Report
Copy link

Link copied!

Hi Anna

Glad to hear.

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

Was this reply helpful? Yes No