Many Record on a subform with only one record on the main form

[losesoul]

I have a form that is a request work order. The main form tells the problems that the employee had, and the subform orders the parts. How do I set up the subform to except many records on the same main form. The error I get is each record on the subform must have a matching on the main form.

 

[ineuw]

It sounds like your tables may have a one to one link. On the table level, (use the relationships window to see if this is set up correctly). Make sure that there is a one to many link between the Main table and the Parts table. Then, you link the Main form to the subform in the subform properties.

Main table EmployeeID (PrimaryKey, Unique one per employee) -> Parts table/EmployeeID (Indexed many records per employee)

Link Master and Child fields with the EmployeeID fields of both forms.

 

[TheAceMan1]

How are ya losesoul . . . . .

Have a look at the following:

[blue]Normalizing Tables[/blue]

http://support.microsoft.com/default.aspx?scid=kb;en-us;209534&Product=acc2000

[blue]Table Relationships[/blue]

http://support.microsoft.com/default.aspx?scid=kb;en-us;304467&Product=acc2000

See Ya! . . . . . .

 

[willir]

losesoul

How is the request work order ... problems that the employee had linked to the subform orders the parts ??

Have you entered the parts per the work order? ...or do want a "template" for the problem to be used populate the subform?

Richard