Value List with Condition
Hey folks, Sorry if it's been explained 1000 times before, but I can't seem to find the answer I'm looking for while searching the forums. My table has several fields, including the following: Lastname, Firstname, FullnameCalc(Last, First), Status. My goal is to create a value list of FULLNAMES, but with the condition Status=Client. Most solutions I've found to this point require the Fullname field to be a "stored indexed field" as opposed to a calculation. The only discussion I've found on "conditional value lists" are for people trying to make two drop downs with the second's values dependent on the first. Would anyone be able to help walk me through this or even point me in the right direction? Thanks in advance!