autofill field 1 with "Yes" if date field not null
There are two fields: Orientation Yes/No (but I'm using TEXT not a check box) and Orientation DAte. The default value for Orientation is "No". How can I have that automatically change to "Yes" if a date is entered in the Orientation date field? The client would like most viewers to see only Yes/No. THanks.