Creating a Form from Multiple tables

[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

 

[June7 via AccessMonster.com]

Use Form designer or wizard to aid in building the form. Select the
appropriate table for the form's RecordSource. Bind combo boxes to the
table's fields. Set combobox RowSource queries to the field that will provide
info for users to select from.

Then do same thing with Report designer/wizard to create the summary. The
report's RecordSource will involve a Join of several tables and text boxes to
display the data. Use grouping and sorting to get desired records and calc
subtotals/totals if needed.

If you are still lost, suggest you query web for tutorials or get a good
reference book. Here is one site:
http://forums.aspfree.com/microsoft-access-help-18/access-tutorial-videos-197463.html

 

[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?

 

[June7 via AccessMonster.com]

Not sure what you mean by 'would not allow me to store the values'. All
depends on how you have the form/subform RecordSources set and the
parent/child link property set and which fields the controls are bound too.
Description of your data relationships is vague and gives no clue on how you
get into a new record. Check out this site for tutorials (the 'sticky'
threads at top):
http://forums.aspfree.com/microsoft-access-help-18/

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?

Use Form designer or wizard to aid in building the form. Select the
appropriate table for the form's RecordSource. Bind combo boxes to the

[quoted text clipped - 26 lines]

 

[June7 via AccessMonster.com]

Sorry, forgot about the screen shot from earlier post. Plenty of detail but
just having hard time following the issue narratively. Would be happy to look
at the project if you want to load to a file share site (such as Box.net).
Post link to the file here.

Not sure what you mean by 'would not allow me to store the values'. All
depends on how you have the form/subform RecordSources set and the
parent/child link property set and which fields the controls are bound too.
Description of your data relationships is vague and gives no clue on how you
get into a new record. Check out this site for tutorials (the 'sticky'
threads at top):
http://forums.aspfree.com/microsoft-access-help-18/

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.

[quoted text clipped - 18 lines]