On the Add/Edit page, I want to prevent a field from being written to the database in the Before Record Added event. In searching the forums I see numerous references to "unset" which I do not believe is an option in ASPRunnerPro 6.3. Any suggestions on how to accomplish this?
Background: I need a dropdown list of courses that is dependent (or filtered) on the course type. I set up a dependent dropdown in the lookup wizard to do this and therefore needed to include the course type as a field in this table of selected courses. But I do not want to save the course type in the table to which I am adding the selected courses. A separate course table manages the course ID, course name and course type fields. Knowing the ID of the course, I can find the course type in the related course table. If I record course type in the table of selected courses and the course type changes in the course table there's a problem.
This is no different than the Make/Model examples in the help guides, but I can't help but think "why record the model"? The model is implied from the make in a relational database.