automatically add records to linked table

[bcrozier]

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 tabe1 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?

[ajetrumpet]

are you asking if you can import data OVER old data on the LEFT or RIGHT side of a relationship?? I assume these tables are related?? if they are, and the table that needs to be overwritten is on the RIGHT or CHILD side, you don't need to do anything. simply overwrite the old data.

if it's on the left AND you've got RI enforced on your relays, they will need to be deleted via code or some other method before every import. Otherwise Access will give a message similar to:

"x records were not imported due to ****** violations..."

[bcrozier]

Thanks, I hadn't considered the possibility of Access making a fuss about me overwriting table1 (left.) Doesn't seem to be a problem though if I just delete the link first, delete table1, import new DBF, remake relationship.

Another poster on another forum has given me a query to insert into table2 and it seems to work. Not quite as seamless as I had hoped for my non-tech user but I can give them a follow the bouncing ball that will do.

Thanks again.

[ajetrumpet]

marked as solved. if you crosspost, tell us.