Form Development from scratch Dynamics Ax 2012 R3 part 1

Consider a scenario where we are going to build small Hospital Admission System in Dynamics Ax 2012. This Add-on is based on small database design based on

http://dhdurso.org/articles/ms-access-database-ad.html

We divide this task into two posts

For this post, we are cover following points to develop this small add-on

Ax Project
Patient, Diagnostic and admission table.
Simple list page for diagnostic table.
Entry form for Patient table (Detail form).
Parent Master detail form based on Patient ,Diagnostic table and patient.
List page for Patient table.
Integrate Patient List page with Patient Detail form.

AX Project:

AX Project for collecting Ax artifacts in single location.

When we create any Ax object they have to create under certain node. For example tables, forms, Classes, menu all stored in their respected node.

In Dynamics Ax we can create a Project which is not more the logical grouping of all Ax artifacts.

In these project, we create object groups and then placed our required object either drag and drop from AOT or create them here.

Advantages of Projects are

Logical grouping, it’s easier to locate required artifacts one location.
When we export project as Xpo, All objects are exported as single XPO.
We can export whole project into model, all object in project moved from one model to other model in single steps.

Lets make a new project

From top menu Click on View=> tools=> Project

Following Screen will open

Right click on Shared folder and create a Project and renamed it to HospitalManagementSystem.

Click on Project and open it. Right click on it new => Group to create new groups

For example we create Form group and set it Name and Project Group type to forms

Now Project is look like

Similarly create other groups.

Table structure design.

So our table structure look like

Diagnostic table

Column	Extended data Type	Primitive Data Type
DiagNo	DiagnosticNumber	Str10
Desc	Description
Cost	AmountCur	Real

Patient table

Column	Extended Data Type
PatNo	PatientNumber	Str 20
Fname	Name
LName	Name
BirthDate	BirthDate
Address	T_Address	Str 20
City	T_City	Str20
State	T_State	Str20
Zip	T_Zip	Str20
Gender	T_Gender

AdmissionsTable

Column	Extended Data Type	Primitive Data Type	Foreign Key
AdmitNo	AdmissionNumber	Str20
PatNO	Patient Number		Patient table
Diag_code	Diagnosticnumber		Diagnostic table
Adminationdate	FromDate	date
DischargeDate	ToDate	date
CoPay	Notes	Notes

First we create a extended data type required in three tables.

First one is DiagonisticNumber extended Data Type

Rename it and set its name as “DiagnosticNumber” and its string set its size to 10

Similarly create all extended data type

Rest of we use out of the box extended Data Type

When you save any Extended Data Type, Ax ask for Synchronize database cancel it when all extended data Types created let it complete

In current example only gender is enum type, we create new base enum T_Gender instead of using out of box Gender enum.

Create a new Enum and name it “T_Gender” t stands for training.

Right click on it and create a new element

Set its name and label

Base Create one more element and it will look like

Now create a click on tables group and right click and create a new table

Rename it to “DiagnosticTable”.

Now create a new field with Name “DiagNo” of string type and set its extended data type to “DiagnosticNumber”

Similarly create all other fields in table

Now expand field Groups node in Table and Create a new Field group with Name “OverView”.

Drag all fields in it.

Now want to make the Diagonistic and unique and make it primary key. For this right click and create unique index on it

Rename it to DiagNoIx and set its AllowDuplicate Property to No and Alternate key to Yes

Now drag DiagNo from fields node to DiagosticIdx.

Now right click on DiagnosticTable and set following Properties with newly created Index

Perform same steps to create PaitentTable, create Index on “PatNo” similar way.

Create a new field group with overview and arrange field in a way that you want to see them in form

Create unique index on PatientNumber

Similarly create AdmissionTable,

Now right click on Relation node in AdmissionTable and create a new relation and rename it to “PatientRelation” and sets its table property to “PatientTable”