Solved

Deleting records

Posted on 2003-11-04
5
344 Views
Last Modified: 2010-04-27
i have duplicated a record in my database. when i delete one of the duplicated record in the file, i realise that the other record is deleted too. the script command that i assigned is only delete a record ( Not delete all record ). How could i prevent this from happenning
ps:- This file get its record from another file through a relationship.
0
Comment
Question by:treynathan
  • 2
  • 2
5 Comments
 
LVL 30

Expert Comment

by:weed
ID: 9684380
When you have relationships set up its just like having the other database IN your current database. Changes to one, affect the other. There is only one record, the one in the related database. When you delete it, its gone.
0
 

Author Comment

by:treynathan
ID: 9699024
i realize that.. but then again.. when you create a relationship, you do have an option whether to have the related record in the other database to be deleted together when you delete a record in the current database. I didn't go for that option. and so i assume that if i delete in this database, no record will be deleted in the related file. the problem is.. i duplicated a record in the current database, when i delete record 1, record 2 also get deleted (see example). This is what i don't understand!
example record 1:  database 1       database 2
                             customer          service
             record 2:  customer          service ( duplicated version of record 1)
0
 
LVL 30

Expert Comment

by:weed
ID: 9701331
Deleting a record in the current database, and deleting a related field in the current database are different beasts. If the field is from another database itll get deleted in the only one it exists in.
0
 
LVL 3

Accepted Solution

by:
Mariano_Peterson earned 50 total points
ID: 9718856
Can you please be a bit more descriptive in your description of the problem?  It's somewhat difficult to understand what you are describing.

When you write that deleting record 1 also deletes records 2, do you mean that:
record 1 and record 2 are deleted from database 1, or
record 1 and record 2 are deleted from database 2, or
record 1 and record 2 are deleted from both database 1 and database 2?

In your example above, there are actually 4 records:

database1 -> record1
database1 -> record2

database2 -> record1
database2 -> record2

How are you deleting the records?  Are you deleting them via a script, or are you deleting them directly by going to Records > Delete Record or clicking "ctrl+E"?

How many relationships are in your database?  Do you have any self relationships?  Do any of your other relationships specify to delete related records?  I have a feeling that you may have multiple relationships, one of which deletes related records.  Perhaps you are only examing the first relationship (which might not specify to delete related records), but the second or third relationship might be set to delete related records (and might alsoo be based on different key fields).
0
 

Author Comment

by:treynathan
ID: 9719445
hey... thanks... i manage to set right things. you were right abt the multiple relationship. I didn't realise that i set the seft relationships to delete the related records. As you are aware.. i'm still very new to filemaker (only two months) Thanks again for answering my questions with patience.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question