Can you append records to a table that has a relationship with another table, or does the relationship have to be deleted first. Thanks.
Scott Axton
@Reply 4 years ago
Not quite a simple yes. But yes, you can append records to pretty much any table.
If there is a dependency on other records in a different table so as not to create orphaned records it becomes more complex.
A little bit of explanation what you are attempting or wanting to accomplish would be useful here.
Ravi PillayOP
@Reply 4 years ago
I want to import an employee list from excel (150 employees). I have the relationships set up with other helper tables and contacts table just for testing. I can delete all the relationships and contact information, would that work?
Thanks.
First and foremost make a back up of your db. Then try out your import on a copy of your data to make sure it is doing what you want it to. You should be able to maintain your relationships. Just a little bit more involved.
The videos above should help you out.
Ravi PillayOP
@Reply 4 years ago
Thank you Scott.
Kind regards.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access TechHelp.