Update other table when editing table

[elenaaralla]

Hi,

I'm trying to add a user when create a customer; I used lookup editor to open user dialog (1) and when save user, it is correctly selected to customer form (2)

What I need now is to save field CustomerId on UserTable after saved the customer itself, i.e.:

1. Save customer data
2. Read the Id of inserted Customer
3. Set User.Customerid = Custoner.Id
4. Save User

How can do this?
Is there an example or documentation on how to do it?

Thank you,
Elena.

[luongnv6]

pls try in abcSaveHandler:

 protected override void AfterSave()
        {
            base.AfterSave();
            if (IsCreate)
            {
                if (Connection.Exists<UserRow>(
                    UserRow.Fields.Username == Row.Email |
                    UserRow.Fields.Email == Row.Email))
                {
                    throw new ValidationError("EmailInUse", Texts.Validation.EmailInUse.ToString(Localizer));
                }

                string password = "deffault_password";

                string salt = null;
                var hash = UserHelper.GenerateHash(password, ref salt);

                Connection.Insert(new UserRow
                {
                    Username = Row.Email,
                    Source = "site",
                    DisplayName = Row.FirstName + " " + Row.LastName,
                    Email = Row.Email,
                    PasswordHash = hash,
                    PasswordSalt = salt,
                    IsActive = 1,
                    InsertDate = DateTime.Now,
                    InsertUserId = 1,
                    LastDirectoryUpdate = DateTime.Now,
                    CompanyId = Row.CompanyId
                });
            }
        }

[elenaaralla]

Hi @luongnv6,

this helped me!

Thank you