relationship tables not relating?

[LLX]

theirs a odd bug in my database and it really has me stumped. See the database tracks subscribers and issues sent out to them but while the issues set database contains to correct reference number (companyid from the records db) its not loading the unique id and thus throwing of various auto calculations and not showing up in the portal in the records list that shows issues sent to that subscriber.

And i can't locate the discrepancy in the "off files"

i use file maker pro 9.

see sample screen

[Fitch]

I'd like to help but your description is hard to follow.

From your screenshot I see that some Subscribers records have no related CompanyID in the Records table.

But since I have no clue how those related Records records get created, I have nothing to go on. Are they related by CompanyID? Do they get created by a script?

[LLX]

In a nut shell I hope this helps

They say a picture speaks a thousand words so I hope my relationship graph is helpful

Basically CompanyId (in Records) is a auto enter auto increment serial

Sent ID is a auto enter, auto increment serial in the issue sent out table.

To tie a "issue" to a Record via a portal you manually enter the CompanyID.

if you notice the SentID they are not sequential so the records dropping of are not from some chronological sequence, its seemingly random. Additionally the "blank records" do have a corresponding CompanyId of the same number but duplicating the record, or retyping the number has no effect.

the un effected records however i can change their company idys and they update properly.

Screen shot 3 shows a (censored) sample of a "working" and "broken" record.

Edited June 13, 2008 by Guest

[Fitch]

And where does "Error" get its value?

[LLX]

error is a calculation...one sec

in Records

GetRepetition ( Issues Sent::Error ; 1 )

in IssuesSent Error is set manually as 0 or 1

[LLX]

did some more tests

Create a new issues field and manually enter data

if i enter a "working" id once issue number, volume, and number sent are set the record ID fills out.

ifi enter a ""broken" record it's still blank so it's not the record files themselves that are buggy but something with those specific IDS

I duplicated a record and put in the new company id that is generated

Still blank

i create a totally new record with some junk data and changed the id to match

still blank

i'm really lost as to whats going on its obvious any new data will have this problem judging by my new record test but the "Broken" issues are not a chronological entry going by the SentIDs