I need to append another record (about 10 fields out of 200 fields) to a table (Table 1) which is one of 5 linked tables of duplicate starting data. Each table is used to store unique values acquired by field technicians. So, each table holds exactly the same number of records (909) and they are correctly identified by the Access ID which links them.
When I attempted to simply add the 10 fields manually to Table 1, an error popped up when I tried to save that this will require adding the same record to the other linked tables (or something to that effect).
I considered de-linking Table 1 but I suspect that this would ruin all my current queries and forms which rely on the current Table 1 link.
So, my question is: how do I safely append the extra record?