Parent-child (foreign key) relationship between forms - just can't figure it out in Creator

Parent-child (foreign key) relationship between forms - just can't figure it out in Creator

Hello Zoho support - would someone be able to look at my application to tell me what I'm doing wrong?

I am modifying the Order Management app in Creator.  I have a subform in Product called Add/Edit Items.. this is where I scan in individual serial numbers of the products.

There is a lookup field in the subform, but for some reason it is just pulling all of the IDs of all the Products, not just the one in the parent form.

I'd like to use this relationship and show the parent Product's part # in the Items report.

Any help?

I'm quite experienced with object-oriented programming and SQL/Oracle, but cannot figure this out!

Thanks!