Adding Records to a Sub Table

[rmarty]

I know this should be fairly strait forward but I am having problems. I have two tables "Acct" and "AcctDetails". The Acct table has the fields(ID, SSN, and Name), while the AcctDetails table has the fields(ID, Date, Amount). I import a table that that needs to be loaded into the AcctDetails table, but It won't allow me to add them through VBA Code due to integrity issues. Does anyone have an easy way to take care of this?

Thanks

 

[PHV]

Seems you have to add to the Acct table the new IDs.
As you said nothing about your actual code, I'm afraid I can't say more useful thing ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886