on 08-02-2010 1:10 PM
Hello Experts,
As both caluculated option and assignment option are 'Table specific', is it possible to copy one field value to other field which is in a different table???
Please share your views in this context.
Thanks and Regards
Eva
Hi Eva,
You can copy only display field value of one table to another table field through assignment.
please try at yr end by opening table in which you assigned values as current table and create an assignment for particular field and select the value of other table in lookup value selection dropdown.
Hope it help you getting yr solution.
For more help please inform us.
Thanks,
Sudhanshu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Eva,
Your assignment is perfectly fine, IF(IS_NULL(copyfield),countryname.name)
assignment is executing succesfully but i dont see any data in copyfield.
See, you will not able to see record if the record on which you are executing Assignment does not have value filled for main table lookup field countryname.
I understand as you said that subtable has 1 record but nevertheless that subtable record is not associated with main table record field countryname, you will not get value through this assignment. Since if this value of maintable lookup field countryname is null, So on executing this assignment for this main table record for field copyfield it will populate blank.
So make sure that if you are going to run assignment on main table record then for that main table record countryname lookup field value is not null. I mean if this Countryname lookup field has value IND then on executing assignment your field copyfield will get populated with IND.
Kindly revert with result.
Regards,
Mandeep Saini
i tested successfully.
So to conclude, if you wish to copy a field value cross table then there are 2 options.
Firstly if the source is DF then we need to go for assignment option.
IF the source is non-DF then we can use caluculated option at field level.
I tested both successfully.
Thanks guys.
Kind Regards
Eva
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.