I need to have a custom collection and custom collection item that will get displayed in Debtor Maintenance and updated when debtor saves, the additional table that is being added to hold this data will have foreign keys to debtor, inventory classification and an inventory category, I am aware of the following things:
1. Makes sure the table is setup with cascading deletes so the database will still allow Jiwa to delete debtors for example and clean up my table as well
2. The collection Item save should not start a transaction nor should it perform a commit or rollback, where a rollback is concerned or would normally occur throw an exception.
3. Check in the save start of the debtor that everything is valid in the collection for the save and then in the save end of the debtor save the collection
4. In the create, read and copy of the debtor take appropriate action for custom collection namely clear, read and clear respectively
Are there any other gotchas I should be aware of beside these to make it work?