I want to try and create a custom form that will provide needed elements for a classic side by side Bill to , Print to: address pair on a print format. I have a few warehouse locations and I want something delivered to one of them.
If would like to simply add custom fiels that link to tabWarehouse address_line_1, city, state etc. How do I do this in the context of the Options in a way that the custome address field will populate with the address of a selected Target Warehouse in Purchase Order?
When I issue a Purchase Order or Request for Items, I want the address of the Traget Warehouse that I select from dropdown to appear on the Purchase Order that I send to Supplier so Supplier ships the Item(s) to the Target Warehouse.
I thought I would create custom fields for the Target Warehouse to add to Purchase Order. I want those fields to be poulated upon selection of the Target Warehouse. The image in my original post shows one of the custom fields and the manner that I have tried to fetch the address of the Target Warehouse from the tab_Warehouse table.