Auto Fill- Combo Bx only updates one Field, Need multiple fields u

  • 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 are buyers in 2005 to save time I would like to lookup and auto
fill data from the 2004 table into the new 2005 table

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

Is it too late to review your database design? Having a 2004 table and
a 2005 table is not the best approach here. A simpler way would be to
have a Buyers table, and a YearsActive table. Some sample data might
look like this...

Table: Buyers
BuyerID BuyerName OtherBuyerData
1 Fred
2 Wilma
3 Barney

Table: YearsActive
BuyerID BuyerYear
1 2004
1 2005
2 2004
3 2005
 
PAR,

There are various ways to do what you are asking in Access. One would
be to set upp to select the 2004 buyer, and run an Append Query to add
their details to the 2005 table. However, the first choice is to use
Access relationally as a database, which is why I made my previous
suggestion.
 
Back
Top