Table - collection of rows and columns   EDT(Extended datatype) - Inheritance, code easy readability, lookups,- 2 RELAtions [Normal and RFF [where clause]   example : select * from custtable - is normal   select * from custtable where gender == female is RFF   How to add columns to the Lookups [Index, Titlefield1, 2 or autolookups]   Q) How to get lookups??   In 3 ways   - EDT, AutoLookup,Relations   Q) what is base enum???   Set of literals or constants which will never change   - example [week - s,s,m,t,....] enums are stored as integers and max - 250   can be accessed by using :: [scope resolution]    Indexes   why do we use index ?- faster performance in select queries  Not to allow duplicates  FieldName Followed by Idx = AccountNoIdx   Field groups:   Autoreport - ctrl + p   Autolookup   almost all the fields should fall under a fieldgroup - on the forms - field groups will form as Group control     Relations on table  :   How one table is related or linked to another   Normal - ...
Microsoft Dynamics Ax,AIF,Axapta, Enterprise portal,,Microsoft , United State,U.S., SharePoint , BI Tools, Performance Tuning, SSRS,Business Logic,Ax ERP Errors and solution,Dynamics 365 Errors Solution,Business software .