Is there a way that when I add Data to one table, that it would automatically populate another table?
In other words, if I have two tables referenced together by Name.
Say my first table is MAIN and my second table is CAP.
And they reference together by Name.
If someone adds a Name to the Main table, can I have it automatically go over to the CAP table?
So both tables stay in sync?
Same goes for deleting, if it is deleted from Main, also have it delete in CAP.