0

Update fields from another table.

In this Table 'Enter Data', when enter the 'Last Name' need Update all fields os Clients table in the 'Enter Data' Table

6 replies

null
    • Fred
    • 2 mths ago
    • Reported - view

    Have you tried the Trigger after update for Last_Name? Is Last_Name a dynamic field or a reference field?

      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 mths ago
      • Reported - view

      The Last Name is a choice dynamic field

      • Fred
      • 2 mths ago
      • Reported - view

      can you post the code you have tried so far?

      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 mths ago
      • Reported - view

       

      No code Fred 😪 

    • Fred
    • 2 mths ago
    • Reported - view

    May I recommend you try the record() command. Something like the following in the Trigger after update of Last_Name:

    let xdata := record(tableindynamicfield,number(Last_Name));
'First Name' := xdata.'First Name'
etc....
      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 mths ago
      • Reported - view

      Work perfect Fred thanks again.

      let xdata := record(Clients,number(Last_Name));
'First Name' := xdata.'First Name';
Street := xdata.Street;
Number := xdata.Number;
Zip_Code := xdata.'Zip Code';
City_ := xdata.City;
Email := xdata.Email;
Phone := xdata.Phone
Login to reply

Content aside

  • Status Answered
  • 2 mths agoLast active
  • 6Replies
  • 60Views
  • 2 Following