Delete Record Deletes TABLE

[MelJ]

I have three tables in a file. Two of the three I have no problems with. But the "Measures" table is getting my goat. Whenever I try to delete a record, all records get deleted.

I'm not dealing with a portal. I'm working with the main table. I've tried a recover but to no avail. I usually exaust all of my resources before bothering others with my problems and that's where I'm at now.

Any Ideas?

Thanks,

Mel

[m-sky]

How are you deleting - from a script, with a keystroke, from the menu? You might also check the relationship - is it based on a global, or on a field with data that is the same for all records in that table?

[LaRetta]

You might also check whether there is a self-join relationship and it is set to Delete Related records when Main record is deleted. If the join is based upon cartesian join, it will wipe them all out.

BTW, if you're ran Recover on that file it should NOT be used again. Recover is only for data retrieval. The design usually suffers damage (and the damage may not be visible either).

[MelJ]

Thanks to both of you!

Laretta, you almost had a direct hit! It was because of a relationship but it wasn't a self join. I'll have to take the time to find out what a "Cartesian" relationship is. I may be using one already and not know what it's called.

Unending thanks to both of you.

Mel

[LaRetta]

Cartesian here

In the relationship graph, it's the X. Any two fields (even if empty) can be used in the join (except containers, I think). All records relate to all records. It isn't easy to find in FM Help. If you search for cartesian, you won't get a hit. It is referred to in a few bubble texts such as 'Changing Relationships' point 3 underlined as Operators and in 'Types of Relationships.'

Relational Operators aren't well documented in Help. I suppose it's because they seem self-descripting. But X isn't. A sentence or two on cartesian product would have been nice.

LaRetta