Need Help

[Ron]

I have two tables in my database. I have a form with fields to input
information. One this form I have fields named DocumentID and Description.
What I want to do is take these two fields, join them together and then input
this information into another table called training. Can someone help me with
this?

 

[KARL DEWEY]

You did not say why you want to put the data into table called training. I
will assume that you want to keep training records on the documents. If so
you need a table for employees also.
You need a hierarchy like this ---
Documents --
DocumentID - autonumber - primary key
Description - text
Employee --
EmpID - autonumber - primary key
LName - text
FName -
MI -
etc. -
Training --
TrainID - autonumber - primary key
DocumentID - number - integer - foreign key
EmpID -- number - integer - foreign key
TrainDate - DateTime

Create one-to-many relationships between [Documents].[DocumentID] and
[Training].[DocumentID]. Also between [Employee].[EmpID] and
[Training].[EmpID].

Use a form/subform for viewing and data entry.

 

[Ron]

I have all of that. What I am trying to do is when a document is created, I
want to clcik a button and the document ID and description in automatically
inputed into the training table. For example,
DocID: QSP-0001
Desc: Doc Control

I want this information inputed to,
Training Requirement: Doc Control
Training Info: QSP-0001

You did not say why you want to put the data into table called training. I
will assume that you want to keep training records on the documents. If so
you need a table for employees also.
You need a hierarchy like this ---
Documents --
DocumentID - autonumber - primary key
Description - text
Employee --
EmpID - autonumber - primary key
LName - text
FName -
MI -
etc. -
Training --
TrainID - autonumber - primary key
DocumentID - number - integer - foreign key
EmpID -- number - integer - foreign key
TrainDate - DateTime

Create one-to-many relationships between [Documents].[DocumentID] and
[Training].[DocumentID]. Also between [Employee].[EmpID] and
[Training].[EmpID].

Use a form/subform for viewing and data entry.
--
KARL DEWEY
Build a little - Test a little

I have two tables in my database. I have a form with fields to input
information. One this form I have fields named DocumentID and Description.
What I want to do is take these two fields, join them together and then input
this information into another table called training. Can someone help me with
this?

 

[John W. Vinson]

I have all of that. What I am trying to do is when a document is created, I
want to clcik a button and the document ID and description in automatically
inputed into the training table. For example,
DocID: QSP-0001
Desc: Doc Control

I want this information inputed to,
Training Requirement: Doc Control
Training Info: QSP-0001

Why?

Relational databases use the Grandmother's Pantry Principle: "A place - ONE
place! - for everything, everything in its place".

If you're storing the DocID in the training table, that's ALL that you need to
store in the training table. Storing the Desc redundantly in the training
table wastes space, and runs the risk of data anomalies - suppose you decide
that the correct description for QSP-0001 should be "Document Validation"
instead; if you have the description stored in x many records in the training
table, you'll need to track them all down and fix them!

You're using a relational database. Use it relationally! If you want to see
the document description in conjunction with training data, USE A QUERY
joining the two tables (or a combo box or one of the many other tools Access
provides).