I am running 12 03 on OSX and Windows.

 

I have two versions of the same program; versions 999J and 999H.  The main Members Layout is based on Members table.

 

On the left (in red) is a portal based on a TOC of Members that when selected, a GTRR script is run and in the main Members section (to the right) the correct member detail is shown.  This works.

 

The problem:  When I click a 'delete' button, in v 999H it deletes a single record.

                                                                ... in v 999J the same script deletes ALL members?

 

 

So, I assume it is a problem with the relatinship between the portal TOC and the Main Members Table?  They are the same.

 

Allow Delete is turned OFF in both.   The Filter is the same in both and when turned off doesn't make a difference.  The Sort is the same.

 

So, if the script is the same.  And the relationships are the same, "What could cause a cascading delete in one and not the other?)

 

Got it!

I missed a TOC based on Members that had the 'Delete' box checked.  So, when I deleted the portal member it deleted the Members Member which cascaded to the TOC which had the Records box checked so everything got deleted.

 

Nothing is so clear except to those who have at last seen the light.

Ron,

 

Is it possible that another relationship between these tables has a cascading delete in 999J that might be involved? Are there any script triggers in play that you have overlooked?

 

Respectfully,

Levi

 

 

-- 

Laura (Levi) Vie

Lead Programmer/Account Manager

Filemaker 11 Certified Programmer

Filemaker 10 Certified Programmer

Filemaker 9 Certified Programmer

Filemaker 8 Certified Programmer

EXCELISYS - http://www.excelisys.com

E: [email protected] V: 573-874-5176

 

- FBA Member

- FileMaker 7/8/9/10/11/12 Certified Developers & Consultants

- Designers and Developers of the FileMaker Business Tracker

Hi Laura, and Welcome to the Forum.

 

Why are you duplicating your Profile information in each of the body's of your post?

So sorry, I didn't mean to. its a signature thing. I will try to clean that up for you.

 

Levi