Is it possible to create a new record using the Record Finder? Or if there are other form widget that's built for this feature?
For example, in a Department, there are Officers.
If an officer already exists in the database, the user can just select the officer to be added to that department.
However, if the user intends to assign an officer to a department which does not yet exist in the database, there would be a form that will automatically create the officer and then assign it to the department.
Is this possible? Currently, I am using RecordFinder with Repeater, since the relationship is Many to Many. Thank you!