I have 2 Forms "Buy" and "Sell" with 2 reports ("Available" and "Buy report") based on "Buy" and 1 ("Sell Report") on "Sell".

Can someone help me with the code to Fetch the records of "Buy Form" to "Sell form"? i have a lookup field called "Model" , So i can use that to create a relationship with the forms, am i correct?

as last, is it possible to have a "On success action" on the "Sell Form" where it takes away the quantity of the "Available report"?

Thanks Guys!