Copy field from a view into another field

(1) Share

Report

Posted on by FabFab97

Hi everyone,
I created the Field AZBProductivityUnit in the table CustPackingSlipJour and inserted it in the form CustPackingSlipJournal. This field of type String needs to be populated with the address of the warehouse associated to that line, so I have to copy this value inside my AZBProductivityUnit. The address of the warehouse is in the form InventLocation stored in the Data Source LogisticsEntityPostalAddressView under the field Address. In addition to that, the field AZBProductivityUnit should be editable, but this modification doesn't have to change the field Address of the warehouse. Anyone has any tip for me ? I tried several coding solutions but no one seems to fit my problem. Thank you very much to anyone who will help.

All responses (3)

Answers (0)

Sort by

Martin Dráb 241,515 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Don't you have any more specific question? Discussing the parts of the solution that you already know would be a waste of time and it wouldn't help you; focusing on the problematic pieces would make a better sense.
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

Using the warehouse you can find the address of it from the related table using select statement. Are you looking about fetching the data?
Raj Borad 1,590 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can copy the data from view using select statement OR by property of the EDT of the field same as view to your field.

If this not solve your issue, Please share some more details about your query.

Thank you,

Raj