>You could create local updatable views in your dbc for the free tables and then just pull the free tables out of the forms and replace them with the views. I fyou give the view the same alias then nothing else will need to change. The views will update when you tableupdate them and the transaction can be used fully.

Great, will there be any performance impact if some tables have a large amount of records and if I have views for them when in the pick list and data entry in forms? Or, is it running as any table as it pulls the required records on the fly when we need it?

If yes and no, as you mentioned earlier, I will definitely change my Save() method to uniform it to be able to use less code, better performance and to benefit of the transactional commands.