How do I use one table to update another table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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