THANK YOU ALL,, for your suggestions.
We had two tables and our boss wanted the same information in both tables.
After a discussion, we have replicated the required fields in her required table and deleted them from the data entry table and now we do not have to copy the data as it will be entered directly into her required table.
Nicole