DALLASTXPAT Posted February 18, 2005 Share Posted February 18, 2005 Lets say I have 4 fields: 1: Job Title - Which is a text field with a value list of positions we offer. 2: Hour Type - Which is a calculation based on job title. If(Job Title = "Manager"; "Salary"; "Hourly") 3: Amount Per Hour 4: Amount Per Year Below these fields 1 calculations field named "Yearly Amount" looks at field three and does a calculation if true and does another if false. Everything is working great except I want to make this thing dummy proof. My goal is to have either field 3 or 4 show up on the layout or have the opposite blocked out (whichever is easiest) and show one or the other. Since I may have confused you here is what I want in actual data. Somebody selects "Manager" as the Job Title. Automatically the Hour type becomes salary. Since the hour type is salary I want the field of "Amount Per Year" to show up. If that is false I want to see the field Amount per Hour or nothing. Any input would be appreciated. I am very new to this but am learning. Link to comment Share on other sites More sharing options...
This topic is 6607 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