dbTalk Databases Forums  

(Unexpected?) New related records

comp.databases.filemaker comp.databases.filemaker


Discuss (Unexpected?) New related records in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Gert Kok
 
Posts: n/a

Default (Unexpected?) New related records - 12-08-2005 , 07:14 AM






New related records are popping up in my 7.0 database, while I didn't
write anything to those related records.

What rules make that those records are created?

Reply With Quote
  #2  
Old   
Helpful Harry
 
Posts: n/a

Default Re: (Unexpected?) New related records - 12-09-2005 , 12:28 AM






In article <11pgcdqg56v6n23 (AT) corp (DOT) supernews.com>, Gert Kok
<gertkok (AT) keraweb (DOT) nl> wrote:

Quote:
New related records are popping up in my 7.0 database, while I didn't
write anything to those related records.

What rules make that those records are created?
Related records are simply records in another table / file that have
the appropriate data in the link field. Related records can be created
via a portal in the main file / table or in the related table / file
itself - these records could be created manually, by a script, or by
importing data.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)


Reply With Quote
  #3  
Old   
Howard Schlossberg
 
Posts: n/a

Default Re: (Unexpected?) New related records - 12-09-2005 , 11:17 AM



Helpful Harry wrote:
Quote:
In article <11pgcdqg56v6n23 (AT) corp (DOT) supernews.com>, Gert Kok
gertkok (AT) keraweb (DOT) nl> wrote:

New related records are popping up in my 7.0 database, while I didn't
write anything to those related records.

What rules make that those records are created?

Related records are simply records in another table / file that have
the appropriate data in the link field. Related records can be created
via a portal in the main file / table or in the related table / file
itself - these records could be created manually, by a script, or by
importing data.
And with or without having any portals anywhere. The key is that you
have your relationship definition set with the option to 'allow record
creation' turned on.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California

FileMaker 7 Certified Developer
Associate Member, FileMaker Solutions Alliance


Reply With Quote
  #4  
Old   
Gert Kok
 
Posts: n/a

Default Re: (Unexpected?) New related records - 12-09-2005 , 02:24 PM



The problem is not how to create those records; the problem is to
prevent records I didn't ask for getting into existence.

I'm not aware of places where I write data into those related records,
yet after updating a parent record I do see new child records, empty.

Gert

Howard Schlossberg wrote:
Quote:
Helpful Harry wrote:
In article <11pgcdqg56v6n23 (AT) corp (DOT) supernews.com>, Gert Kok
gertkok (AT) keraweb (DOT) nl> wrote:

New related records are popping up in my 7.0 database, while I didn't
write anything to those related records.

What rules make that those records are created?

Related records are simply records in another table / file that have
the appropriate data in the link field. Related records can be created
via a portal in the main file / table or in the related table / file
itself - these records could be created manually, by a script, or by
importing data.

And with or without having any portals anywhere. The key is that you
have your relationship definition set with the option to 'allow record
creation' turned on.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California

FileMaker 7 Certified Developer
Associate Member, FileMaker Solutions Alliance

Reply With Quote
  #5  
Old   
Helpful Harry
 
Posts: n/a

Default Re: (Unexpected?) New related records - 12-09-2005 , 05:41 PM



In article <11pjq0sf7od466a (AT) corp (DOT) supernews.com>, Gert Kok
<gertkok (AT) keraweb (DOT) nl> wrote:

Quote:
The problem is not how to create those records; the problem is to
prevent records I didn't ask for getting into existence.

I'm not aware of places where I write data into those related records,
yet after updating a parent record I do see new child records, empty.
Records can't be created by magic, so somewhere you ARE creating those
records, either manually or via a script - the problem will be finding
where / when that's happening. It's not really anything we can help
with (unless you want to upload the files somewhere for someone with
the same version of FileMaker and some spare time to look into).

Somewhere / somehow either a new record is being created with the same
link data as the parent record, or an existing record is having it's
link data changed to link with a different parent record.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.