your client results recordset is probably filtered by a session variable, right?
create a new recordset for products, your products table should have a column that relates to the client, set that column to filter on the same session variable that the client recordset is using.
use that session variable in the insert record sever behavior when inserting a product.