Referenced Tables for a Screen

This question has suggested answer(s)

How do I get a list of all the referenced table names that are used for a screen?

e.g.  I am on Vendor Maintenance screen (0327000); when I create a new Vendor or Update an existing Vendor; which tables are read/updated?

All Replies
  • Hello MSQ,

    You could look at the Report Assistants at the link below.  They give screen shots of the Dynamics SL screens and point to where the data is stored in the tables.  Let me know if this is what you were looking for.  

    Carolyn

    Technical Support Engineer

    **This posting is provided "AS IS" with no warranties and confers no rights.

  • Carolyn,

    Where is the link to the Report Assistant that you mentioned above?

  • MSQ,

    Sorry - I forgot to include the link.

    mbs.microsoft.com/.../report_assistants_msdyslv6.5.htm sl report assistants

    Carolyn

    Technical Support Engineer

    **This posting is provided "AS IS" with no warranties and confers no rights.

  • Thanks...

  • mbs.microsoft.com/.../msdyn_reportassistantssl2011.htm Assistants  

    is updated for SL 2011

  • 2011 Report Assistants link

  • Use the sql profiler, you gonna see the insert on vendor table for vendor maintenance screen and all the store procedures that use to validate the data.

    You can use the profiler for all processes  and all screens and reports