August 16, 200520 yr I have a HireDate field for each employee. I have a Pay Class field structured as a Pop up Menu with the following list values: 1. A03 2. A01 3. A06 4. Facility I also have 6 textboxes named the following: 1. Review Dates 1 2. Review Dates 2 3. Review Dates 3 4. Facility Reap 5. Facility P& T 6. Annual Review Note: Review Dates 1, 2, 3 are date fields. Question: Please help!! How do I do this? If user clicks on A03 then Review Dates 1 field should be hiredate + 35 days and Review Dates 2 field should be hireDate + 70 days and Review Dates 3 field should be hireDate + 90 days note: results should be in date format If user clicks on A01 or A06 then Review Dates 1 field should be HireDate + 90 days And Review Dates 2 field should be HireDate + 180 days Notes: Results should be in date format If user clicks on Facility then it will populate Facility Reap field with text of “March” and Facility P& T field with text of “June” and Annual Review with text of “December”
August 16, 200520 yr From the information you have provided it appears your "6 textboxes" should be calculations, for example: Review Dates 1 (Unstored, calculation result is Date) = Case(Pay Class = "A03"; Hire Date + 35; Pay Class = "A01" or Pay Class = "A06"; Hire Date + 90) Facility Reap (Unstored, calculation result is Text) = If(Pay Class = "Facility"; "March")
Create an account or sign in to comment