Linking Fields in Multiple Tables

[Guest]

I have a main table called Contract Profile where all the main information
for the contract is stored. I created a query and form for the user to input
contract information. for the Contract profile.

I have several other talbes for Assessing the Contract and want to pull a
few fields from the Contract Profile table (ID (unique, indexed, no
duplicates, primary key); Contractor, Contract Number) to auto populate in
the Assessment tables i've created.

The contract profile will stay the same but several assessments need to be
done throughout the year; therefore, i will need those fields listed above
auto populated anytime i need to create an assessment from one of the
contract profiles. Can this be done?

Any help is appreciated.

 

[Marshall Barton]

I have a main table called Contract Profile where all the main information
for the contract is stored. I created a query and form for the user to input
contract information. for the Contract profile.

I have several other talbes for Assessing the Contract and want to pull a
few fields from the Contract Profile table (ID (unique, indexed, no
duplicates, primary key); Contractor, Contract Number) to auto populate in
the Assessment tables i've created.

The contract profile will stay the same but several assessments need to be
done throughout the year; therefore, i will need those fields listed above
auto populated anytime i need to create an assessment from one of the
contract profiles. Can this be done?

Duplicating data is a big No No. Just use a foreign key in
the assessment table to link back to the related contract
record. Any time you want the data from both tables, use a
query that Joins the two tables.