Search results for query: *

(Sorry about the name mix-up confusion, fly and willer) Fly, your last recomendation was on the money-- I don't know why I missed it in the first place. I now have a macro handling the following: 1) Run append queries for the Parent and Child table to move them into their respective archive...

Thanks very much to both of you for your help. I just want to make sure I've summarized my issue clearly: At the end of each month I need to append whatever's in my Parent and Child tables into the ParentArch and ChildArch tables, respectively. I then run an update query on the Parent table...

Thanks for your help. I had in fact omitted the Parent table's PK (Autonumber) in the append query to the ParentArch table; that was the problem. But now I have a secondary issue: I can run the Parent and Child table append queries succesfully only one time--- when I try to run the same...

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...

I think I made this problem unecessarily complicated. Since all of the Vendor tables contained identical data, it makes more sense to just create a one-to-many with the Customer table as parent and the Vendor table as child. But I didn't realize it until I started to answer the replies--...

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...