My main form "Store Records" contains a subform "Items List".

I added a CRM field on the subform related to "Products" Module.

Is it possible to have the subform act as follow,

1-Creating 4 fields "Product Name", "Product Description", "Quantity in Stock", and "Qty" which is the number of the selected product to be taken from store.

2-When the user select the CRM product in subform the first 3 fields data will also be fetched and auto filled

3-Subtract the amount taken from store and update the remaining quantity in CRM "Quantity in Stock".

Thanks,