cdr-dev Posted January 25, 2005 Share Posted January 25, 2005 I am working on a DB for employee tracking and I have a field called "Employee Status". I have a drop down of 5 items. 2 of wich are the words "Vacant" and "Contract". If I select either of those two words, a second window pops up and asks for two date values that must be entered. If I write a calculation for the "Employee Status" field and define as such. How should I modify my script to where it will bring up a second window that allows me to enter the Request Date and Expiration Date? They can be both assigned the same because they both represent the same result if either is selected. Let("Vacant" and "Contract" = 1), If "Employee Status" = 1, Then open layout "Date menu" Then the two dates would be entered, user would click OK, and close the window. Simple, but what would be the best method to write this? Link to comment Share on other sites More sharing options...
This topic is 6627 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now