Conditional content within a field
So, I tried searching, but I'm kind of unsure as to how to put my question into a "searchable" context. I don't thnk that what I'm looking for is a conditional value list -- but I'm a newb, so maybe I'm wrong about this.
What I have is a database that tracks hourly wages, based on projections for the type of work being done on a given day. The type of work day is designated in a field with a value list, IE: "rehearsal", work, prep, etc. I also have totals being generated for everyone working on a given day, so I know what they're making for an eight hour day and a twelve hour day. What I need is a field that looks at the first field (for the type of work -- say, "rehearsal") and will return the "eight hour day" total, but if the first field says "work" it will return the total for the "12 hour day."
Any help would be really appreciated.