adding info to junction table- not primary keys

[Guest]

I formed a junction table with the primary keys shift id and employee
id...when i make a form i would like to include these 2 ids plus 3 related
fields related to the shift id like day and time which is included in my
shift table.... please help..how come it wont let me include these extra
fields in the form?

 

[Guest]

You need to use a subform.

If you are entering shift information for employees the the main form is the
employee form and shift information the subform. If you are entering
employees to work a shift then the shift is the main form and employees the
subform.

Use queries as source for the forms and subforms and set the Master/Child
links of you main/subform.

 

[John Vinson]

I formed a junction table with the primary keys shift id and employee
id...when i make a form i would like to include these 2 ids plus 3 related
fields related to the shift id like day and time which is included in my
shift table.... please help..how come it wont let me include these extra
fields in the form?

These fields should only be stored in the shift table. You can
*display* them on the junction table subform by using a Combo Box to
store the ShiftID; include the desired fields in the combo's
rowsource, and put textboxes on the form with control sources like

=comboboxname.Column(n)

where n is the zero-based index of the field you want displayed.

Or, base the Subform on a Query joining your junction table to the
shift table.

John W. Vinson[MVP]