2 Replies Latest reply on Apr 13, 2013 11:32 PM by philmodjunk

    Hiding "field B" from layout if "field A" is empty

    SarahJayneDavies

      Title

      Hiding "field B" from layout if "field A" is empty

      Post


           Hi.

            

           I have a database setup to record invoices from one company that are outstanding, have been paid, etc. I have a "Paid" field with a drop down list with values from a yes/no value list, so that I can search for outstanding invoices etc.

           I than have a date field called "Date paid". Obviously, I am asked for a date, regardless of the value in "Paid". I have tried to change things so I am only asked for a date if the "Paid" value is yes.

           So far, I have had no success so wondered whether anybody here could help?

            

           Many thanks.

           Sarah

            

      invoice_database.jpg