i need to take multiple records(row) from FORM and then want to insert into table .

(0) Share

Report

Posted on by Gautam

3,945

hey guys i am just doing a small project in dynamics AX 2012 as i am beginner and new to AX.

In sells form i want to take multiple record at a time and then want to save these data into my sellsTable(table name) and each record consists of these fields that is sellsid, itemid, itemname, itemquantity, itemunitprice, totalcost, date.

so suggest me how should i procceed.

*This post is locked for comments

I have the same question (0)

All responses (25)

Answers (1)

Suggested answer

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

i guess its same question and answer as here

Was this reply helpful? Yes No
Gautam 3,945 on at

Like (0)

Report

no sohaib

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

then, I am unable to understand your issue/ scenario

Was this reply helpful? Yes No
Gautam 3,945 on at

Like (0)

Report

sohaib it may be the answer i dont know excatly .

as i am very new to dynamics AX so i am unable to handle complex things .

my issue is that

i want to take value (multiple record) from grid and want to store into my sell table

and the scenario is that ..

i have made one sellsform(Form Name) for handling the billing regarding selling of products .

so i know how to take a single record from the form by using StringEdit but i dont know how to take multiple record from form .

i can use this StringEdit also here ..but what will happen when a customer buy more than one item at a time .so to overcome this problem i want to take multiple records at a time

my project is of supermarket

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

Gentleman you have to use grid and set multiselect property of grid as true.

Was this reply helpful? Yes No
Gautam 3,945 on at

Like (0)

Report

ok sohaib i have done this ..and one more thing how to get the values from the same grid

as i have created this grid without any datasource

Was this reply helpful? Yes No
Suggested answer

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

As I referred to a previous post

{

YoueTable yourTableObject;

;

yourTableObject = YoueTable _ds.getFirst(true);

while (yourTableObject)

{

//any processing here any logic here;

//for your case you have to insert records in other tables here

yourTableObject = YoueTable _ds.getNext();

}

}

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

I cannot understand why you are not using Datasource for your form, is there any special need, for not using DS??

Was this reply helpful? Yes No
Gautam 3,945 on at

Like (0)

Report

hey sohaib where should i write these codes

i mean i need to override any method of grid ??

if not then where should i ?

Was this reply helpful? Yes No
Gautam 3,945 on at

Like (0)

Report

ok sohaib . let me answer it

i am not using the datasource in grid because when i add the datasource then it will display the values from the table which i don't want .

suggest me what to do here ,if it is necessary to add DS then i will definetly add the DS

Was this reply helpful? Yes No

Community site session details

i need to take multiple records(row) from FORM and then want to insert into table .

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

i need to take multiple records(row) from FORM and then want to insert into table .

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates