Tables:

How to create tables

Open AOT >> Datadictionary >> Tables

Righ click and cerate new table

Name - KAM_CusTable
Label : Customers table - Kamineni hopsitals



Expand the newly created table and you will find a new fields node

Drag and drop all the extended datatypes which you want as  field to fields node

You can even drag and drop the enum on to the table - it will cerate a new enum field



Create a new table with following fields - for all fields - label and help text are important.

Note: help text should always end with . or ?



customerId - EDT - KAM_CusId - 20
Name - standard [Name]
Age - int32
AddressCountryRegionId
AddressZipCodeId
AddressStreet
AddressStateId
AddressCity
JoinedDate - TransDate
Creditlimit - AmountMST
Email
PhoneMobile
Phone
Region - NEW eNUM kam_rEGION AND ADD 4 ELEMENTS IN IT

once you create table - restore option by right clicking the table and chosing the restore option

How to add data to table


Right click on the table >> Open

in older versions it is right click on the table >> add-ins >> table browser

Ctrl + n to create a new record

Alt + f9 to delete a record

Important proeprties on the the field:

Label
HelpText
Mandatory
AlloweditonCreate
AllowEdit
Visible
EDT
EnumType

The system will automatically create 3 new fields in every table

DataAreaId - current logged in company
Recversion - int64 - for concurrent updates
RecId - int64 - unique record id [whern u save a record - interview nd certification question]

How to stop adding duplicates - restrict the redundacy of data


Go to Index node in the table >> right click and new Index >>

Best practise [MS Recommends - ] Index name should ahev the prefix as your fieldname and suffix as Idx

CustomerIdIdx
and also set the allow duplicates property to No

Drag and drop the CustomerId field to newly created index


Why indexes???????????

Index will help you for performance for select statements[Improve performance of select statements]

In Ax - now allow duplicates

Field group : Grouping up of similar fields for easy identification in one place

Right click on the field groups >> New Group >> Give the Name as AddressInfo, label as Addressz information

Drag and drop all address related fields to the nelwy created field group


AddressCountryRegionId
AddressZipCodeId
AddressStreet
AddressStateId
AddressCity

Create 2 new field groups by name contact info and Misc and drag drop whatever fields u want.......


JoinedDate - TransDate
Creditlimit - AmountMST
Email
PhoneMobile
Phone
Region

AutoReport:

AutoReport field group will help to quickly generate a report based on the fields whatever you have dragged and dropped in to it

Drag and ddrop - customerId, Name, creditlimit, city and Email to the autoreport

Ctrl + P OPTION


Thank you!