2. PHPRunner General questions
  3. [SOLVED]  Parent-Child Table links keep disappearing
This topic is locked
[SOLVED]

 Parent-Child Table links keep disappearing

 		4/3/2010 2:22:53 AM
PHPRunner General questions
bbarker author

[size="4"]I am going crazy. Every time that I re-open my project, the 5 child tables to my master Parent table are not linked properly again. Sometimes it still contains one, or two links, sometimes three. But almost never does it RETAIN all five links.
I have "synced" the database a number of times with no effect.
Does anybody have a clue as to why this is so unstable? It is very, very frustrating since I've rebuilt my application about 30 times now and I can't ever trust that it keeps all of my table relationships.
I would VERY MUCH appreciate your suggestions or ideas. Thanks. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=14198&image=1&table=forumtopics' class='bbc_emoticon' alt=':(' /> [/size]
Sergey Kornilov admin 4/4/2010

As a first step make sure you use the latest build of PHPRunner (http://xlinesoft.com/download)
If this doesn't help contact support team directly at http://support.xlinesoft.com sending your project file along with your database.
bbarker author 4/5/2010



As a first step make sure you use the latest build of PHPRunner (http://xlinesoft.com/download)
If this doesn't help contact support team directly at http://support.xlinesoft.com sending your project file along with your database.


I submitted a copy of the database a week ago and then Jane mentioned that there was a new release... So now, I've upgraded to 5242 but the problem persists. So on Sunday I uploaded another full copy of it to the demo area. I'll post the findings once I get a response. Thanks.
N
 		n_ack 4/7/2010



I submitted a copy of the database a week ago and then Jane mentioned that there was a new release... So now, I've upgraded to 5242 but the problem persists. So on Sunday I uploaded another full copy of it to the demo area. I'll post the findings once I get a response. Thanks.


Did you customize any of the "problematic" tables on the SQL-tab? If so, be sure that the linked fields (as defined by the master-child relation on Tables-page) are present in the customized SQL.

Do not omit these fields, or you'll end up with the seemingly random deletion of table-relations.

if you don't want to show your link fields turn them off on tab-Fields, not by deleting them from the customized sql!
bbarker author 4/7/2010

That was the problem... I had unchecked the Foreign key field since I never show them in any report or form. Dang.... I've lost over 4 weeks on this... I feel like an idiot.
Now, I'm wondering if I need to check BOTH of the KEY fields for BOTH tables too? Only one is required on the next screen. (I think it asks for the detail table.)
Like you said, I turn them all off on the tab-Fields later on anyways.
N
 		n_ack 4/7/2010



That was the problem... I had unchecked the Foreign key field since I never show them in any report or form. Dang.... I've lost over 4 weeks on this... I feel like an idiot.
Now, I'm wondering if I need to check BOTH of the KEY fields for BOTH tables too? Only one is required on the next screen. (I think it asks for the detail table.)
Like you said, I turn them all off on the tab-Fields later on anyways.


<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=49040&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' /> Great, glad it worked out!