I am having trouble deleting 3 records in a related database. No matter what I try they will not delete. I have just switched to Filemaker 7 within the last two weeks and everything seemed fine after converting my Filemaker 6 databases until now. The 3 records are in a datebase called Wholesale Invoices. It has two relationships: Wholesale Invoices Line Items and Customers - Wholesale. I have checked the Wholesale Invoices Line Items database and there are no records relating to the Wholesale Invoice Database. I have also deleted the related records on purpose in the Customers - Wholesale database. The 3 records still won't delete.

I want to be able to rid the records in this database and know how to take care of it if it happens again. It's creating records that are messing up reports.

Any advice would be greatly appreciated!

Thanks!

Just off the top of my head: It is possible that the relationship for the file is set to "allow creation of related record". A record is created with the relationship. Try de-selecting this. Another option is select "allow deletion when related record deleted".

Good luck.