i made two tables - one for employee infor and the other for trainings they
take. I linked them together and crated a form to input the data. How do i
get it so the employee table has a pull down for the information and vise
versa - they dont seem to join the info

A well-normalized design for what you describe would involve THREE tables.

One table for employees (with EmployeeID).

One table for Trainings (with TrainingID).

One table to document the trainings they take - a junction table (with
EmployeeTrainingID, plus EmployeeID & TrainingID as foreign keys).

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"smsgroi" <(E-Mail Removed)> wrote in message
news:86C9B41C-DBAF-4A0C-8037-(E-Mail Removed)...
>i made two tables - one for employee infor and the other for trainings they
> take. I linked them together and crated a form to input the data. How do i
> get it so the employee table has a pull down for the information and vise
> versa - they dont seem to join the info

Add to your form a subform based on the trainings table.
When you add the subform, a wizard will guide you through linking your main
form to the subform. They will be linked based on whatever column you joined
the tables on.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"smsgroi" wrote:

> i made two tables - one for employee infor and the other for trainings they
> take. I linked them together and crated a form to input the data. How do i
> get it so the employee table has a pull down for the information and vise
> versa - they dont seem to join the info

smsgroi,

You say the info does not join to gether but prior you say you linked them
together. I am not clear how they are joined together. It seems as though
you are missing a table...

tblEmployeeTraining
etEmployeeID (FK)
etTrainingID (FK)

At which point you could have a Main Form to look up Employees and a Subform
to show what Training they have taken or want to add. It would help if you
post the two tables and the fields along with their relationship to each
other.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"smsgroi" <(E-Mail Removed)> wrote in message
news:86C9B41C-DBAF-4A0C-8037-(E-Mail Removed)...
>i made two tables - one for employee infor and the other for trainings they
> take. I linked them together and crated a form to input the data. How do i
> get it so the employee table has a pull down for the information and vise
> versa - they dont seem to join the info

i believe i did that i have the subform for it with column headings that list
employee names - i just dont have any names to pull down from the empoyee
table- if i go to the sub form it copies the name and adds another- i am
trying to have all names in a pull down menu so i can add them to the
training-

"Dorian" wrote:

> Add to your form a subform based on the trainings table.
> When you add the subform, a wizard will guide you through linking your main
> form to the subform. They will be linked based on whatever column you joined
> the tables on.
> -- Dorian
> "Give someone a fish and they eat for a day; teach someone to fish and they
> eat for a lifetime".
>
>
> "smsgroi" wrote:
>
> > i made two tables - one for employee infor and the other for trainings they
> > take. I linked them together and crated a form to input the data. How do i
> > get it so the employee table has a pull down for the information and vise
> > versa - they dont seem to join the info

smsgroi,

Do you mean you want a Combo Box? You can add one to your form using the
wizard accessible in the forms design mode.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"smsgroi" <(E-Mail Removed)> wrote in message
news:04455695-1ECE-44CA-BC15-(E-Mail Removed)...
>i believe i did that i have the subform for it with column headings that
>list
> employee names - i just dont have any names to pull down from the empoyee
> table- if i go to the sub form it copies the name and adds another- i am
> trying to have all names in a pull down menu so i can add them to the
> training-
>
> "Dorian" wrote:
>
>> Add to your form a subform based on the trainings table.
>> When you add the subform, a wizard will guide you through linking your
>> main
>> form to the subform. They will be linked based on whatever column you
>> joined
>> the tables on.
>> -- Dorian
>> "Give someone a fish and they eat for a day; teach someone to fish and
>> they
>> eat for a lifetime".
>>
>>
>> "smsgroi" wrote:
>>
>> > i made two tables - one for employee infor and the other for trainings
>> > they
>> > take. I linked them together and crated a form to input the data. How
>> > do i
>> > get it so the employee table has a pull down for the information and
>> > vise
>> > versa - they dont seem to join the info

i did that- i just cant get the employee information so i can usea pull down
and add it to the class they took

"Dorian" wrote:

> Add to your form a subform based on the trainings table.
> When you add the subform, a wizard will guide you through linking your main
> form to the subform. They will be linked based on whatever column you joined
> the tables on.
> -- Dorian
> "Give someone a fish and they eat for a day; teach someone to fish and they
> eat for a lifetime".
>
>
> "smsgroi" wrote:
>
> > i made two tables - one for employee infor and the other for trainings they
> > take. I linked them together and crated a form to input the data. How do i
> > get it so the employee table has a pull down for the information and vise
> > versa - they dont seem to join the info

ok i did that - i think how do i get the employee info into a pull down menu
box so i do not have to type everyone in every class they take

"Jeff Boyce" wrote:

> A well-normalized design for what you describe would involve THREE tables.
>
> One table for employees (with EmployeeID).
>
> One table for Trainings (with TrainingID).
>
> One table to document the trainings they take - a junction table (with
> EmployeeTrainingID, plus EmployeeID & TrainingID as foreign keys).
>
> Good luck!
>
> Regards
>
> Jeff Boyce
> Microsoft Access MVP
>
> --
> Disclaimer: This author may have received products and services mentioned
> in this post. Mention and/or description of a product or service herein
> does not constitute endorsement thereof.
>
> Any code or pseudocode included in this post is offered "as is", with no
> guarantee as to suitability.
>
> You can thank the FTC of the USA for making this disclaimer
> possible/necessary.
>
> "smsgroi" <(E-Mail Removed)> wrote in message
> news:86C9B41C-DBAF-4A0C-8037-(E-Mail Removed)...
> >i made two tables - one for employee infor and the other for trainings they
> > take. I linked them together and crated a form to input the data. How do i
> > get it so the employee table has a pull down for the information and vise
> > versa - they dont seem to join the info
>
>
> .
>

As suggested by others else-thread, use a main form for the Employee data,
and a subform for the EmployeeTraining data. On the subform, use a combobox
to list available Training.

You can have Access keep the main form and subform coordinated, so that
every time a new "training" is added, the EmployeeID is added with it.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"smsgroi" <(E-Mail Removed)> wrote in message
news:A1082F64-D192-4FB0-B71F-(E-Mail Removed)...
> ok i did that - i think how do i get the employee info into a pull down
> menu
> box so i do not have to type everyone in every class they take
>
> "Jeff Boyce" wrote:
>
>> A well-normalized design for what you describe would involve THREE
>> tables.
>>
>> One table for employees (with EmployeeID).
>>
>> One table for Trainings (with TrainingID).
>>
>> One table to document the trainings they take - a junction table (with
>> EmployeeTrainingID, plus EmployeeID & TrainingID as foreign keys).
>>
>> Good luck!
>>
>> Regards
>>
>> Jeff Boyce
>> Microsoft Access MVP
>>
>> --
>> Disclaimer: This author may have received products and services mentioned
>> in this post. Mention and/or description of a product or service herein
>> does not constitute endorsement thereof.
>>
>> Any code or pseudocode included in this post is offered "as is", with no
>> guarantee as to suitability.
>>
>> You can thank the FTC of the USA for making this disclaimer
>> possible/necessary.
>>
>> "smsgroi" <(E-Mail Removed)> wrote in message
>> news:86C9B41C-DBAF-4A0C-8037-(E-Mail Removed)...
>> >i made two tables - one for employee infor and the other for trainings
>> >they
>> > take. I linked them together and crated a form to input the data. How
>> > do i
>> > get it so the employee table has a pull down for the information and
>> > vise
>> > versa - they dont seem to join the info
>>
>>
>> .
>>