Hi everyone.
I'm pretty new to Access and i would like to make a simple process so please help out here.
I have a Table A.
I have another program interacting with it and updating it's fields and adding new ones automatically.
I need to do the following.
When a new field is entered into the table i need to automatically run a query which will copy that field to another table (new field) and then delete that field from the original table.
All this is done automatically so i need this operation to be done automatically as well.
How do i do this ?
Basically i need a solution on how to trigger a Query when the table has been updated or a new filed has been added to it.
Please help out.
I'm pretty new to Access and i would like to make a simple process so please help out here.
I have a Table A.
I have another program interacting with it and updating it's fields and adding new ones automatically.
I need to do the following.
When a new field is entered into the table i need to automatically run a query which will copy that field to another table (new field) and then delete that field from the original table.
All this is done automatically so i need this operation to be done automatically as well.
How do i do this ?
Basically i need a solution on how to trigger a Query when the table has been updated or a new filed has been added to it.
Please help out.