Going through a thing of Things to update a field in another thing

Need help Database
1

I am stuck! HELP!

I have two tables (things)
a) Store products : products that a store owner adds to his store.
b) Store product Search: a much smaller table that I will use for users of my App to search products using a keyword, for example, “honey” or “breadboard”…

I think I am using a good approach, but it is not working.

When the store owner is done editing his store (owner info, store info, and store products), I wish to create one record for this store owner in the Store Product Search data table. The field I am most interested in I called SearchTextField and it contains keywords in English and French for the product and the store owner. This is the field I want to use to find store that match the keyword and location (geolocation).

Is there a way to batch create the Store Product Search record by going through all records in Store Products (owner’s store)?

Thanks,
Guy

2

Is there a way to trigger a background (server side) event that deals with that?

3

Solution: I found out about the :merged with operator. Marvelous!