S
Shaun
I am having 5 tables I want to merge the data in one table. For example the
fields of the table is given below for your reference.
Field 1 - Customer Id
Field 2 - Error Done By(Employee Id)
Field 3 - Error Comment
Field 4 - Error Tracked By (Employee Id)
Like that I am having fields in table. Each table consist the same Fields.
Like this 5 tables created and five forms are created.
I have assigned user level security for these 5 tables. For example if one
person is using the first table he can able to access the first table and
first form only. He should not be able to view what the other persons have
entered. So like that I have allocated five table & five forms to five
persons. Now I want to merge all the five table details in one new table
that will be used by the Head who is chief for that team.
So anyone please tell me how to merge the five tables in one new table. If
any one is updating any record in that five table then it should be updated
in the New consolidation table which is used by the Head (chief).
So please provide a solution for this.
Thank you,
Shaun
fields of the table is given below for your reference.
Field 1 - Customer Id
Field 2 - Error Done By(Employee Id)
Field 3 - Error Comment
Field 4 - Error Tracked By (Employee Id)
Like that I am having fields in table. Each table consist the same Fields.
Like this 5 tables created and five forms are created.
I have assigned user level security for these 5 tables. For example if one
person is using the first table he can able to access the first table and
first form only. He should not be able to view what the other persons have
entered. So like that I have allocated five table & five forms to five
persons. Now I want to merge all the five table details in one new table
that will be used by the Head who is chief for that team.
So anyone please tell me how to merge the five tables in one new table. If
any one is updating any record in that five table then it should be updated
in the New consolidation table which is used by the Head (chief).
So please provide a solution for this.
Thank you,
Shaun