2. PHPRunner General questions
  3. master - details relation
This topic is locked

master - details relation

 		9/19/2005 09:42:29
PHPRunner General questions
scuba author

I have a master table linked with a details table. Common key fields are "company". So if I add a new company in master-table shouldn't it also automatically appear in details-table? I my case it doesn't - what am I doing wrong? <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=1884&image=1&table=forumtopics' class='bbc_emoticon' alt=':(' />
Sergey Kornilov admin 9/20/2005

Hi,
you can not add the record in two tables simultaneously.
You can get more information about master-detail relationship here.

Also you can look how it works by the example of Live demo.
scuba author 9/20/2005

thanks for the help here too!
I'm trying to create something like a samll CRM for the comp. I work for. Not beeing able to read out data from one table to another actually means that my co-worker would have to open several tables to add information for one singel customer. That doesn't really make it any easier and might be quite confusing.

If some customer data needs to be in table "customer" and other data needs to be in table "company info" that would mean for me to create a seperate html/php form with each field connecting to another tabel in db in order to add data efficient - am I seeing this right or am I just confused a bit <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=6048&image=1&table=forumreplies' class='bbc_emoticon' alt=':blink:' />
Sergey Kornilov admin 9/21/2005

Hi,
PHPRunner can not do this for you. You need custom programming for this purpose.