Help

  • Thread starter Thread starter Robert R.
  • Start date Start date
R

Robert R.

Could someone tell me how to do the following.
Seems like a simple thing, but have given up.

You input a word in a field in table "A" and it goes to
table "B" and gets data from other fields and automatically inputs three
other fields in table "A".

RR
 
Could someone tell me how to do the following.
Seems like a simple thing, but have given up.

You input a word in a field in table "A" and it goes to
table "B" and gets data from other fields and automatically inputs three
other fields in table "A".

RR
Click to expand...

Well, it's not easy or automatic, largely because it generally Should
Not Be Done.

As a relational database, Access is designed using the Grandmother's
Pantry Principle: "A place - ONE place! - for everything, everything
in its place". As such, if you have three fields in TableA, they
should NOT (generally) be copied redundantly into TableB. Doing so
wastes space, and more importantly, risks data corruption; you could
change the value stored in TableA without making the corresponding
change in B.

Almost always, if you want to see data from the two tables in
conjunction, you should use a Query linking the two tables; or, use a
Form based on TableA and a Subform based on TableB to see the data
together.

If you could explain what these tables and fields are, someone should
be able to suggest a way to get the *data* together without violating
this principle!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top