How do I use one table to update another table

P

PAR

I need to enter data into a database as quickly as possible for an auction.
I have names and addresses from the people who signed up for buyer numbers
the year before. I need to set up an auto fill from the 2004 table for those
people who will be buyers in 2005.

I tried adding the combo box into the header, but can not get it to work
with the new 2005 table.
 
P

PAR

More Info:
I was able to get the auto fill to work by binding the various info boxes to
the original table, but this does not allow me to add new people.

I need to both look up old buyers and add new.
 
T

TheScullster

Do you mean that you are duplicating the personnel details into a second
table simply to register these as 2005 entrants?

More experienced Access wizards will tell you that this is not the way to
go!
Can you not simply add a "Date of Subscription" table and link the existing
entrants to the new and subsequent appropriate years?

Maybe I misunderstood the question!

Phil
 
Top