Populate data in SubForm from other Form

Populate data in SubForm from other Form

Hi there,
I'm a little bit lost creating a subfom script to populate in this subform data from an other form.

Let me explain it:
I have a form (Products) to define products details... In this form, I have the following fields:
- Product_Number
- Product_Name
- Product_description
- Product_Stock

I would like to have a second form (Requests) where I have the following fields:
- Date
- Requestor_Name
and a subform (SubForm_Requests) with the list of all products defined in the Products Form and 1 additional field for each product. So I should have the following fields in SubForm_Requests:
- Product_Name = Products.Product_Name
- Available_Stock = Products.Product_Stock
- Requested_Itme = X

I don't know how to do it... The Deluge script should look similar to this:

for each Products.Product_Number
{
insert into SubForm_Requests
Product_Name = Products.Product_Name
Available_Stock = Products.Product_Stock
}

But I spent few days trying to figure out how to write this script and I never been able to make it run !!!
Any advice to do it ? Thanks,

Pierre.