Options

Populate a field in a From,from another table.

I have Created one field called "Customer Balance" in Sales Order form.That field (Customer Balance) has to auto populate(get the balance) from the table's("Customer"(18)) field Balance.

Answers

  • Options
    DrakonianDrakonian Member Posts: 14
    So you have 2 way:

    1. Make your field "Customer Balance" as flowfield on Table36, with method LookUp and link by Customer from Table18. Do not forget to make it not editable.
    2. Create function which will be get Table18 and return Balance value.
  • Options
    KarenhKarenh Member Posts: 209
    get the customer record. Calcfields(Balance). then put Cust.Balance in the form.
  • Options
    Jacob1227Jacob1227 Member Posts: 128
    Thanks, Drankonian and Karenh
Sign In or Register to comment.