Good morning,
I've 3 tables (tbl_Medical, tbl_Employee & reference table tbl_EmpMed).
fMedical in tbl_Medical is the standard frequency of each medical examination but they can be personalized if there is a need.
Frequency in tbl_Emplyee is the personalized frequency for each Employee.
My goal is that if the Button A in tbl_Employee is true the personalized frequency is used to create the next deadline. If the button is false the standard frequency is used.
I create the deadline in my query1 with A1: DatAdd("m";[Frequency];[mDate])
Best regads
Georg
I've 3 tables (tbl_Medical, tbl_Employee & reference table tbl_EmpMed).
fMedical in tbl_Medical is the standard frequency of each medical examination but they can be personalized if there is a need.
Frequency in tbl_Emplyee is the personalized frequency for each Employee.
My goal is that if the Button A in tbl_Employee is true the personalized frequency is used to create the next deadline. If the button is false the standard frequency is used.
I create the deadline in my query1 with A1: DatAdd("m";[Frequency];[mDate])
Best regads
Georg