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.