Find and delete script

[Daniel Blake]

I don't know FM at all, but I need to do this for a client.

FM Pro 5 POS app created with four databases

(roster, inventory, sales, line item)

inventory database doesn't have a quantity field so every item is a separate record. The inventory database is getting very large.

I need to find all the items in the inventory database that have been sold (have matching barcode field data in the line item database) then delete all records found from the inventory database.

barcode is a number field - I think this is what is screwing up my find.

find view in inventory database, placed this in the barcode field.

==(line item::barcode)

Where can I find good documentation on creating scripts for FM Pro 5?

Daniel Blake

[Ugo DI LUCA]

Hopefully, you did duplicate your post.

So you want to delete records in the Inventory file, not in the line items...

Change the calc given in you DUPLICATE post. Use it in the Inventory file instead of your line item, using a relationship Barcode::Barcode.

Case(IsValid(Yourrelationship:barcode),1,0).

Delete records where the calc returned a 1.