Problems with Insert on Table from Form

carioka
carioka Member Posts: 20
Hello.
7000002 in the table in the Account No, I gave it to me bring in OnValidate name from Account No. When you insert the data from the table works fine, but when inserted in a Form not working and not running for Onvalidate the Talba.

Comments

  • Savatage
    Savatage Member Posts: 7,142
    Just to clarify..

    You have a table
    It has the field account no.
    When you enter the account no. you want it to pull up the name.
    you say it works when you enter the account no directly into the table but thru a form the name is not appearing.
    You feel the Onvalidate trigger on the table isn't being triggered when you enter data using a form.
    Is this what you're asking?

    What code you you have Onvalidate of the account no on the table?

    What code you you have Onvalidate of the account no on the Form?
  • carioka
    carioka Member Posts: 20
    Savatage wrote:
    Just to clarify..

    You have a table
    It has the field account no.
    When you enter the account no. you want it to pull up the name.
    you say it works when you enter the account no directly into the table but thru a form the name is not appearing.
    You feel the Onvalidate trigger on the table isn't being triggered when you enter data using a form.
    Is this what you're asking?

    What code you you have Onvalidate of the account no on the table?

    What code you you have Onvalidate of the account no on the Form?
    On the OnValidate of my table i have one filter with refresh another field (name customer) of my table. If i insert row on my talbe the code works correctly, but if i insert a new row from Form the field name customer dont have data.
    Sorry but my english is very very very very bad :P
  • Savatage
    Savatage Member Posts: 7,142
    Savatage wrote:
    What code you you have Onvalidate of the account no on the table?

    What code you you have Onvalidate of the account no on the Form?

    a filter won't refresh another field. is your code similar to below? the form shouldn't be effecting the code unless something else is going on. Perhaps theis "filter" you're referring to is set on the first line only? Or perhaps you're not leaving the field to complete the validation. Do you have a currform.update command on your form?

    OnValidate of account no (of your new table)
    if customer.get("new table"."account no.") then
    "new table".name := customer.name;