I would like to add several text fields to the employee maintenance screen and what is to be added exceeds the user defined fields available so it requires the creation of a new SQL table, linking that table into the screen and then adding fields from that table to the screen. The SL documentation of how to do this and what the VBA code needs to include is sparse at best. I have the table created and introduced to the screen such that Customization Manager now sees the new table and the fields can be added to the screen. Since it appears that SWIM will not process these fields, I understand that code needs to be added to handle the display, inserting, updating and deleting of these fields but there is no documentation on what such code should look like and under what events it needs to be added. I have the populating of the fields working but not the updating or inserting and was hoping someone has done something similar (with an SL screen) and would be willing to share the VB code they created to do that.
By the way, the new table is a one-to-one relationship to the employee. It is holding items like emergency contact name and number, email address of the employee, cell number for the employee, etc.