Populate a field in a From,from another table.

Jacob1227

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.

Drakonian

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.

Karenh

get the customer record. Calcfields(Balance). then put Cust.Balance in the form.

Jacob1227

Thanks, Drankonian and Karenh