how can we show one form values into another form

Get our Free Newletter

Don't you have the time to be online here at DUG every day? So how do you follow what is going on in the Dynamics industry and community?
If you subscribe to the DUG Newsletter then you can relax! We will make sure that you don't miss the big news!

Check out our
Newsletter Subscription Center
page a complete list of our different newsletters.

Solution (Verified) This post has 1 verified solution | 17 Replies | 1 Follower

95 Posts
1,008 Points
Joined: 2012-11-8
Last Online:
2013-2-27 14:09
Location: INDIA
pressi posted on 2012-12-4 11:03

hi every one,

i have two forms like accountability and approval form.while iam entering the data into accountability form when i click submit function it will goes to the approval form..but i have 3 field ref no,quater,and description..these fields does not existing data.

i set the table relation for the forms even though the values are not getting..plz give me reply 

Solution (Verified) Verified Solution

4,879 Posts
125,039 Points
Joined: 2009-2-17
Last Online:
2014-7-31 18:49
Location: Hyderabad, India
DynamicsNAVMVP
Moderator
Solution (Verified) Mohana replied on 2012-12-4 13:07
Verified by pressi

Yhen you need to add code to assign new field values also..

All Replies

4,879 Posts
125,039 Points
Joined: 2009-2-17
Last Online:
2014-7-31 18:49
Location: Hyderabad, India
DynamicsNAVMVP
Moderator
Mohana replied on 2012-12-4 11:11

What are the tables behind those forms?

Are they same or different?

If different, How are you inserting data from accountability table to approval table?

using TRANSFERFIELDS and assigning via code?

95 Posts
1,008 Points
Joined: 2012-11-8
Last Online:
2013-2-27 14:09
Location: INDIA
pressi replied on 2012-12-4 11:23

Different tables like accountability has general line table and approval has approval line table..but some common fields is present inthat form..some fields like line no,document no,amount values are inserting while clicking submit into accountbaility form..Remaining rf no,ref decsription,quater does not have values.

in the function button i can use this transfer code??

4,879 Posts
125,039 Points
Joined: 2009-2-17
Last Online:
2014-7-31 18:49
Location: Hyderabad, India
DynamicsNAVMVP
Moderator
Mohana replied on 2012-12-4 11:35

If some fields are flowing means there must be code written with TRANSFERFIELDS or assigning..

Please check what code is written..

If transferfields is used then you must have same field ID and data type in both tables..

95 Posts
1,008 Points
Joined: 2012-11-8
Last Online:
2013-2-27 14:09
Location: INDIA
pressi replied on 2012-12-4 12:03

ya the 2 fields has same id in the two tables..i added one field in the approval line table so can i add in the field in the gen.journal table.where can i write the codein that field validate trigger??

can u suggest me that code

 

4,879 Posts
125,039 Points
Joined: 2009-2-17
Last Online:
2014-7-31 18:49
Location: Hyderabad, India
DynamicsNAVMVP
Moderator
Mohana replied on 2012-12-4 12:18

Check the code under submit button first.

How the field values are flowing to approval table..

95 Posts
1,008 Points
Joined: 2012-11-8
Last Online:
2013-2-27 14:09
Location: INDIA
pressi replied on 2012-12-4 12:51

it has one codeunit like workflowmanagement in that insertapprovingline function is there in that fileds are assigning .when we r submitting it will go to linedistribution buffer.

4,879 Posts
125,039 Points
Joined: 2009-2-17
Last Online:
2014-7-31 18:49
Location: Hyderabad, India
DynamicsNAVMVP
Moderator
Solution (Verified) Mohana replied on 2012-12-4 13:07
Verified by pressi

Yhen you need to add code to assign new field values also..

95 Posts
1,008 Points
Joined: 2012-11-8
Last Online:
2013-2-27 14:09
Location: INDIA
pressi replied on 2012-12-4 13:19

k thank u

95 Posts
1,008 Points
Joined: 2012-11-8
Last Online:
2013-2-27 14:09
Location: INDIA
pressi replied on 2012-12-5 10:22

hi mohana i added the field in codeunit..2 fields are flowing into other form..one field was not flowing..that field is option field..i added this field in temporary table..how i can write code for option string??

..i wrote for the two fields like this


  TempLineDistBuffer."Receipt Ref. No." := GenJnlLine."Receipt Ref. No.";
  TempLineDistBuffer."Receipt Description" := GenJnlLine."Receipt Description";
  TempLineDistBuffer.Quater := GenJnlLine.Quater;//this one was not gng to another form..plz suggest me

4,879 Posts
125,039 Points
Joined: 2009-2-17
Last Online:
2014-7-31 18:49
Location: Hyderabad, India
DynamicsNAVMVP
Moderator
Solution (Not Verified) Mohana replied on 2012-12-5 10:24
Suggested by Mohana

I think values from TempLineDistBuffer table will be inserting into final table..so please check that place also..

95 Posts
1,008 Points
Joined: 2012-11-8
Last Online:
2013-2-27 14:09
Location: INDIA
pressi replied on 2012-12-5 10:34

I checked that one also..but  this option string field is not effecting.

4,879 Posts
125,039 Points
Joined: 2009-2-17
Last Online:
2014-7-31 18:49
Location: Hyderabad, India
DynamicsNAVMVP
Moderator
Mohana replied on 2012-12-5 10:40

Try to print the value in above code using

Message('%1',GenJnlLine.Quater)

check what is the result..

95 Posts
1,008 Points
Joined: 2012-11-8
Last Online:
2013-2-27 14:09
Location: INDIA
pressi replied on 2012-12-5 12:17

Only displaying what i selected in the option filed..it does not affecting on the other form

4,879 Posts
125,039 Points
Joined: 2009-2-17
Last Online:
2014-7-31 18:49
Location: Hyderabad, India
DynamicsNAVMVP
Moderator
Solution (Not Verified) Mohana replied on 2012-12-5 12:32
Suggested by Mohana

Did you check also in TempLineDistBuffer.Quater field..after assigning the values.

Are you sure you have added the code in assigning values frpm TempLineDistBuffer.Quater  table to end table?

Page 1 of 2 (18 items) 1 2 Next > | Get this RSS feed | Bookmark and Share