Field Selection to create & Delete a Record

[Jscott]

I have a field that is either a yes or no. If someone selects yes, it creates a record into another related Table and that part works fine. But what I want to do is that if they had selected yes and created the record and then go back and select no that the related record is deleted automically without dialog.

Stumped yet again...

Thanks

[Raybaudi]

If someone selects yes, it creates a record into another related Table and that part works fine.

Hi

how did you manage that part ?

[Jscott]

Because the Field that is in Table 2 is defined within Table 1, so when they select yes, it creates a record in Table 1 automatically.

[Raybaudi]

...and the primary key is ?

BTW: if i'm understanding you correctly, your primary key is the check field and you are checking that field inside a portal.

If so, attach this script to that check field:

If[isEmpty(table1::check)]

Set field [table1::check;"Yes"]

Else

Delete portal row [no dialog]

End If