AnsweredAssumed Answered

Populate a child foreign key from parent key

Question asked by LENDALNA on Mar 6, 2016
Latest reply on Mar 7, 2016 by fitch

I have two tables - Vendor and Vendor Address - as we receive raw materials from vendors with multiple plants and warehouses. The following is my script code for my button on Vendor. I have also the foreign key to auto enter using the following calc

 

Vendor Address::Vendor_ID_FK = $$VendorID - When I run the button it either fills in a 0 or nothing at all in the child field. I put a merge variable field on Child Layout to see what value my Variable $$VendorID had and it's correct. If I manually fill in the field and then go back to the Vendor layout the Else segment code works. I'm really stumped as I can't see what I'm missing. Any help would be appreciated.....

 

add vendor address.tiff

Outcomes