auto populating

[Ryan]

Hello,

not sure how to do this but what I need to do is have one
table get info for a field by pulling information from 2-
3 other fields and then use this new field as the link
between tables.

Is this possible

 

[Jeff Boyce]

Ryan

Good relational database design frowns on building a composite field
("information from 2-3 other fields). If you need a field (or fields) to
serve as a key to another table, there are a couple approaches.

One would be to include as many (key) fields in the related table as you
have in the primary table.

Another would be to add an autonumber primary key field to the primary
table, and use THAT as your key "relating" field in the secondary/related
table.

 

[John Vinson]

Hello,

not sure how to do this but what I need to do is have one
table get info for a field by pulling information from 2-
3 other fields and then use this new field as the link
between tables.

Is this possible

It's a VERY BAD IDEA. Yes it's possible, but it is neither necessary
(to do what you describe) nor wise.

Note that you can use up to TEN fields as linking fields in a Query.
You don't need to store data redundantly in order to do this. Or, you
might do better to add a unique field as a primary key in one of the
tables (an Autonumber if you don't have a good natural key) and use a
compatible foreign key in the other table (Long Integer if you use an
autonumber); you would then use a Query to link to the first table to
retrieve these two or three fields rather than storing them
redundantly.