O'Reilly logo

Developing Microsoft Dynamics GP Business Applications by Leslie Vail

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating tables and keys

Your project requires two new tables: one in which to store the contacts and another in which to store their phone numbers. Because you would like to create tables with names longer than eight characters (Imagine!), you need to change an option in Dexterity.

Select Edit | Options from the menu bar. In the Table Options section of the Options window, mark the checkbox next to Allow Long Physical Table Names. With this option marked, you can create table names with up to 28 characters.

The 28-character limitation is imposed by Dexterity, not by SQL.

Creating tables and keys

Tables

You will use the Table Definition window to create your tables. In the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required