My situation is this. I've got access database which contains 4 tables, and some other forms/reports etc. It look like this.
This is first part of database, and it works fine. Second part is this:
I need same "subdatabase" (same tables, data type...) "Stavke_Usluge" etc. except "Korisnici" table. This is becouse "Korisnici" is unique for all other data.
My question is how to copy - paste "Korisnici" as "Korisnici_new" without making C/P every time, best way is some kind of script after update.
This is like scheme of my idea, but doesent work. (Users are unique, but data from other tables are different).
![]()
thank you for your time, Bajaz
EDIT:
Clone would be nice to, or just same forme that updates both of tables at same time.