how can we show one form values into another form

Business Central/NAV User Forum
1

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

2

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?

3

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

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…

5

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

6

Check the code under submit button first.

How the field values are flowing to approval table…

7

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.

8

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

9

k thank u

10

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

11

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

12

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

13

Try to print the value in above code using

Message(’%1’,GenJnlLine.Quater)

check what is the result…

14

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

15

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?

16

I checked that one

17

thanks mohanaa i added the field and i got the answer

18

Welcome [:)]