Hello,
I have split my database into front-end and back-end for distribution. However, since one of the tables is used for data entry on-the-fly (which admittedly is considered "bad practice" but is the most effective way for these users to interact with this data), I have this table present in the front-end database. These tables appear like so:
However, what I've just noticed, is that it seems that these tables are not writing changes to the back-end database. Are these basically just a copy of those tables that I've been appending/updating? Is there a way I can make sure that the tables do make changes to the back end, or should I just go ahead and leave this DB un-split, since I'm kind of using it that way anyway?