FORMS - one entry but multiple fields get filled in

  • Thread starter Thread starter R Nordin
  • Start date Start date
R

R Nordin

For example, if I pick the "part number" from a combo box
in table "A" with a row source type of "TABLE" that is
selecting from table "B".....how do I get a few of the
associated columns from the same row in table "B" to show
up in unique coloumns in table "A"?

I just want to have a fast way to copy data from one
table to another by selecting only data from one column?

Thanks
 
Actually, you don't really want to do that. Access is a relational database.
Relational databases are designed so you shouldn't need to ever store
duplicate information in multiple tables, except for those values that link
tables together. You can always run a query to pull the information from
Table B.
 
For example, if I pick the "part number" from a combo box
in table "A" with a row source type of "TABLE" that is
selecting from table "B".....how do I get a few of the
associated columns from the same row in table "B" to show
up in unique coloumns in table "A"?

I just want to have a fast way to copy data from one
table to another by selecting only data from one column?

Thanks
Click to expand...

Step back a bit here.

The whole POINT of a relational database is to avoid redundancy,
thereby avoiding redundancy. If you have the data in TableA there is
very rarely any good reason to copy the same data into TableB.
Instead, create a Query joining the two tables on some appropriate
linking field (PartNumber?) and display fields from both tables.

Could you explain what these two tables contain, and what (in a
real-world sense) you're trying to accomplish?
 
Back
Top