I have an unusual request- is there code that will allow the user to update a table that list the name of the Mandatory fields, that can be used to validate which fields are required on which form at any given time?
My client is requesting some flexibility in the design of the database allowing the Admin to modify which fields are required (mandatory).
My thought was to create a table that will store the name of the fields, table name. Then use this table to verify which fields required data and this will allow the admin user to turn on and off which are mandatory on the fly without coding.
any ideas will be greatly appreciated.