Identical tables for different user data.

[Bajaz001]

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.

[HiTechCoach]

You might do what you are asking in a spreadsheet where you duplicate a worksheet but that is really not how it is handled in a relational database.

You want to avoid having tables with duplicate structures. They should all be in a single table with an additional field that identifies the group or category

Of the three sub related tables, probably only the first one down will need the extra field to identify the group/category. The other two related tables can use the data from the first table.