Solved

Deleting records

Posted on 2003-11-04
5
339 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

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…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

757 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now