access forms and tables

[smsgroi]

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

 

[Jeff Boyce]

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.

 

[Dorian]

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".

 

[Gina Whipp]

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]

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-

 

[Gina Whipp]

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]

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

 

[smsgroi]

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]

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.