Unanswered: automatically add records to linked table
I'm new to Access and I just need to determine whether this can be done.
I have one imported DBF table1 with basic customer info from an ERP system. I've linked it to a second table2 in Access that I populated with records by copying and pasting table1's ID column. The two tables are linked and I have a simple form with fields from both tables. I'd like to be able to maintain table2 with new user data but update table1 with a fresh import that might contain new records from the ERP. I want the new records to show on the form and automatically add to table2 so that the user can maintain table2 data for them. I've played with integrity enforcement and cascading fields but no luck. Can this be done in Access?
Thanks, step 2c was all I needed. I want to completely ovewrite table1 because some fields in old records may have changed. And I don't need to delete any records in table2 because records in table1 are almost never deleted.
ANother poster on another forum pointed out a problem overwriting a linked table1 but I just deleted the link first, deleted table1, imported the new DBF, ran your insert into query, and remade the link. Seems to be okay on quick inspection but if you see a problem with this let me know.
Not as seamless as I hoped but not bad. Thanks again.