Friday, December 2, 2011

Quick and Dirty way to see Window Resources

Need to see the tables and fields related to a particular window in GP?  Here's how - open the window, select Tools>>Integrate>Table Import.  The Select a Table window opens and displays all the tables assoicated with the window (this works only in GP10 and later versions).

* click image to enlarge

* click image to enlarge

if you need to see the fields in a specific table, double click on the table name in the Select a Table window.  The Table Import Definition window opens.  Enter Test or some other value in the Definition ID field.  Note that the fields appear in the scrolling window.  Make sure you delete the definition when you close the window.

* click image to enlarge

2 comments:

David Musgrave said...

Hey Frank

From your screenshot you have the Support Debugging Tool installed.

So why not use the Tables Associated with Form lookup and then once a table is selected, use the table lookup to explore the fields.

Support Debugging Tool Portal:
http://aka.ms/SDT

David
http://blogs.msdn.com/DevelopingForDynamicsGP/

Frank Hamelly, MCP-GP, MCITP, MCT, MVP said...

Thanks David - right you are! I offer this for those who may not have SDT installed :) I also use Rockton's GP Toolbox sometimes but the SDT is the best!

Frank