How to achieve table relation in SQL without primary index 1:n

HI,

Select particular parent table (master table) db.table.

1. Right click select design

2. Select the respective field where we have to achieve unique index but not primary.

Right click on that filed select Indexs/keys...

3. Add the select the column to from that list and please make sure you change the property to YES in isUnique.

4. Save and select the design of transaction table where we try to achive Foreign key.

Right click on that particular filed and choose Relationships..

5. Add the relationship by select the tables and columns specifics.

Regards,

 

RandomNumbers In AX /D365

 Hi,

static void CreateRandomNumbersInAX(Args _args)

{

    RandomGenerate randomGenerate;

    ;

    randomGenerate = RandomGenerate::construct();

    randomGenerate.parmSeed(new Random().nextInt());

    info(int2str(RandomGenerate.randomInt(0,2147483647)));   //RandomInt(RangeFrom,RangeTo)

    //Note: Range from should be more than natural number 0 and more.

 

}

OutPut

1786303728

To understand the formula behind this random number please refer randomInt() in RandomGenerate class.

The formula in randomNumber generation is not similar to library function of dotnet.

Note: We cannot treat this randomGenerated Values as primary key, this may repeat with same range.

Regards,