I'm wondering if this is possible:
I have a form to insert a new record (row) into the database. There are several fields, but depending on what is chosen in the Department column, not all of the other fields are necessary. Is it possible to make the required fields be dependent on what the value of the Department column is?