Adding data to form automatically

  • Thread starter Thread starter Frank Watson
  • Start date Start date
F

Frank Watson

Hi
Access 2003
I have two tables, the main one A has an auto number. The
second table B is for payments received. I have been re-
entering some of the data into the Form in B table,
however I would like to know how to set up Form B whereby
I just enter the auto number of table A and have the data
automatically entered for me. I hope this makes sence and
would appreciate some ideas.
With thanks
Frank
 
Hi
Access 2003
I have two tables, the main one A has an auto number. The
second table B is for payments received. I have been re-
entering some of the data into the Form in B table,
however I would like to know how to set up Form B whereby
I just enter the auto number of table A and have the data
automatically entered for me. I hope this makes sence and
would appreciate some ideas.
With thanks
Frank
Click to expand...

If you're storing the same data in TableB as you already have stored
in TableB... DON'T!

The whole POINT of a relational database is to avoid redundancy. Store
the information in TableA; if you need to see it in conjunction with
data in TableB, use a Query joining the two tables. You can display
the data on FormB using a Combo Box if you wish - perhaps you could
explain what's in the two tables and what you want to see.
 
Hi Frank, the main purpose of Access (as compared with
Excel) is to only enter the data once in a table . By
providing a Relationship (link) between the two table
you can extact the information you need by using a query
(based on the two tables) as an input to a form or
report etc.
 
Back
Top