This topic is locked
[SOLVED]

Update field in table2, value coming from table1

7/20/2021 5:18:52 PM
PHPRunner General questions
J
Jan Desaer author

I’ve got master table “PERSONS” and detail table “HOURS” with link PERSONS.ID to HOURS.PersonID.
I’ve got 2 records in table PERSONS. When I add 1 record in HOURS, I need to choose 1 of the 2 records in PERSONS. The dropdown is (PersonID) is working, but the field “TARIF” in table HOURS must be updated to the value coming from table PERSONS for that record.

I.e.:
PERSONS:

  • record 1 with “Tarif” 10
  • record 2 with “Tarif” 20
    Adding record in HOURS when choosing record 1 from PERSONS, means “Tarif" in HOURS must be updated to “10”.
    Adding record in HOURS when choosing record 2 from PERSONS, means “Tarif" in HOURS must be updated to “20”.

How can I do this?

Thanks for the support.

HJB 7/26/2021

AUTOFILL BASED ON TWO FIELDS SELECTION

... for inspiration purposes only ...

J
Jan Desaer author 7/26/2021

@HJB

Thank you so much. This is what I was looking for.
I had put everything in the sections "Befor Client" and "Server". But thank you for the explination.

Have a nice day.