We have 4 locations that product is sold and delivered from.  Keeping track of the items sold is simple enough.
I have a separate database for each location's delivered items.
At the end of the day, they are updated so we know what is delivered and what is still pending.

The challenge is to merge the information so we can prioritize based on date.

I made a form in our Inventory database that all stores get:  SOLD ALL STORES. The 4 separate databases SOLDSR SOLDSM SOLDANT SOLDNG post to the SOLD ALL STORES form.

What I need to do is setup that the records for each location are  deleted before the day end up.

Here is the basic information:

Database:  INVENT.DB
FORM: SOLD ALL STORES
RETRIEVE SPECS: SR SM AN NG

I currently have a Command Button that Checks for Delivered items and updates the Sold databases for each store.

Is there a quick command that I can insert to Search the SOLD ALL STORES form and remove the records?

Hi Ray,

I'll give it a try.  I wasn't sure if the XResult Delete would work in this case.

You're getting that error message because you're not including sbasic_include.sbas so Sesame doesn't know what SEARCH_MODE_AND means.

-Ray