Jump to content
Sign in to follow this  
LLX

relationship tables not relating?

Recommended Posts

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

Picture_1.png

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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.

Picture_2.png

Picture_3.png

Edited by Guest

Share this post


Link to post
Share on other sites

And where does "Error" get its value?

Share this post


Link to post
Share on other sites

error is a calculation...one sec

in Records

GetRepetition ( Issues Sent::Error ; 1 )

in IssuesSent Error is set manually as 0 or 1

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.