I need to create a Parent - Child relationship between APTran and ARTran tables. The artran.OrigInvoiceLineNbr field has no value (value is NULL) on the existing data. Can I populate this field with the APtran.LineNbr value for reference in the ArTran table?
relationship between APTran and ARTran tables
Userlevel 7
+10
It is always safer to use your own fields -- this way you do not risk interfering with standard system behaviour or getting impacted if the field is removed or renamed in the future.
Thank you for the prompt response and valuable feedback.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.