Bringing Table Information Into a Subform

[RoundTrip]

Hello everyone, I hope everyone is having a wonderful V-Day!
Anyways I have a question about Subforms, and how to utilize it to work in a way I see it in my head!

I have A form where I enter information as follows in order as well
{Report Number, Date, Location, Equipment No., Field No, Crop, Operator, and then WorkOrder Number}
Now when I type in the WorkOrder Number, I am wanting to go into detail of what was used on that WorkOrder. So I will be using a Subform below the Workorder label. Now I have a seperate table for the information that will go in the subform and the fields that will be used in that subform is as follows
{Product(s),Amount Used}
So Basically what I am saying is, I want to be able to type in a Workorder Number, And then when I enter my information in the subform for those two fields (Products and amount used) then no matter how many records I do in that subform it automatically saves it to that certain workorder number.

Now another question regarding this, does this mean I would have to set WorkorderNumber as a primary key or foreign key or what would my steps be here? Thankyou very much for the help

[June7]

That's what form/subform arrangement is intended for. Set the subform container control Master/Child Links properties to the primary and foreign key fields and the value will automatically save to the related child record.

Whatever the primary key is in the WorkOrder table should be the value saved to child record as foreign key. If WorkOrderNumber is not the primary key then there is no reason to save to child record.

[RoundTrip]

I have it figured out now except one minor problem, If I want to keep the workorder record blank for any odd reason, like if we did not use any products at that time then how can I make it where it does not pop up with a window saying
Index or primary key cannot contain a null value

[June7]

That error should only happen if a record on the main form is initiated by data entry into a field and only if you have a non-autonumber field set as primary key. Did you set the WorkOrderNumber as primary key? Can press ESC key to undo edits.