Create a script. The pseudo-script might look something like this:
Go To Layout [ layout based upon this table ]
Enter Find Mode [ uncheck pause ]
# below, enter whatever fields are necessary to confirm that the record is truly blank. The equal means empty field
Set Field [ FieldA ; "=" ]
Set Field [ FieldB ; "=" ]
Set Field [ FieldC ; "=" ]
Set Error Capture [ On ]
Perform Find [ ]
If [ not Get ( FoundCount ) ]
Show Custom Dialog [ "no records found" ]
Delete All Records *
Go to Layout [ Original Layout ]
Note that the script step 'Delete All Records' only affects records in the current found set. This script can be manually fired each day or you can use FM Server script to run it.
Ideally, you would address and solve the issue of creating unwanted records because, between the time the records are created and subsequently deleted, someone could generate a summary report which, for example, derives the average price of products based upon the number of orders, or they are counting orders and their figures would be incorrect.
You also risk the problem that someone might create a child record from one of these blank records and then you will have child orphans when you delete the parent.
Worked perfectly - we're not doing summary reports so much right now, at least, based on # of records, so I can fire this off manually every few days just to keep things clean .... perfect!