Creating a Form from Multiple tables

  • Thread starter Thread starter Damian
  • Start date Start date
D

Damian

Hello again,

First, let me post this screen shot:
http://img41.imageshack.us/img41/5121/reltables.jpg

What I would like to do and learn is to create a form so that the user can
select each person from TblCrew and assign to them seperate jJobID from
TblJobs.

Then I need them to do the same thing for TblSubcontractors BUT they will
only fill out jNumberOfForeman & jNumberOfWorker from TblJobs.

Then I need a summary of all entered data for specific day/date.

Thank You in advance,
Damian
 
I tried to create a form with subform, But it would not allow me to store the
values I put it the subform in a table.

Consider these 3 tables from this screen shot.
TblCrew
TblJobs
and a link table between them TblJobDetail.

I wnt to create a form where the user will be able to first choose the
CrewType from combo box, then in the next combo box will choose the name that
corresponding to the choice he made in the first box. Then he will ender
values for jNumberOfForeman etc from TblJobs set as a subform or whatever
will work. So that I can later look at cCrewID 1 or 2 or 5 and see the
NumberOfForeman/ Worker/ Laborer for each of them.

How can I do that?
 
Back
Top