Deleting records that match a linked table.

[James D. Houston]

I'm trying to delete records in an Access table that match records in a
linked Foxpro table. Running the table generates the following warning
message:

You won't be able to undo the changes this action query is about to make to
the data in a linked table or tables.

I want to delete the matching records in the Access table and leave the data
in the linked Foxpro data alone. Can anyone tell me how to do that? The
SQL for the query is below. Thanks in advance.

DELETE DISTINCTROW Curbf.*, Curbf.OrderNumber, cpsh.MANIF_DATE
FROM Curbf INNER JOIN cpsh ON Curbf.OrderNumber = cpsh.INVOICE
WHERE (((Curbf.OrderNumber)=[cpsh].[invoice]) AND
((cpsh.MANIF_DATE)>#6/30/03#));