Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: djswitters
- Content: Threads
- Order by date
-
Append Query Key Violation Error
My apologies in advance as I know similar questions have been asked, but I can't figure this out based on other threads: I have two joined tables that need to be archived (appended) monthly. For illustration, call them Parent and Child. Parent's PK is an Autonumber, which is joined in a...- djswitters
- Thread
- Replies: 7
- Forum: Microsoft: Access Tables and Relationships
-
Multiple Tables One-to-One Problem
I'm an Access novice and would really appreciate some help getting my head around this: I have a table called Customer w/ PK CustomerID (autonumber). I then have 8 other tables, called Vendor A, Vendor B, Vendor C, etc. Each of these 8 tables has a field CustomerID as their PK, and each of...- djswitters
- Thread
- Replies: 3
- Forum: Microsoft: Access Tables and Relationships
