2. PHPRunner General questions
  3. join tables
This topic is locked

join tables

 		8/20/2007 1:51:15 PM
PHPRunner General questions
H
 horsey_kim author

I am trying to create invoice screen at the top I want to have customer info, shipping, terms and such. Then at the bottom of the screen I want to have line items that people can select products from a products table. When it is saved I want an auto generated number to be saved also that would be saved in the customer table, and each product item in the product table. I am thinking the auto generated number would be the tie for the tables in generation of view and printing and such.
Would it be better for me to create master-detail connection in views then from the tables? Any advice?
confused as usual?
Kim
Sergey Kornilov admin 8/20/2007

I think master-details relationships will work the best for this purpose.
H
 		horsey_kim author 8/20/2007

I think master-details relationships will work the best for this purpose.


Is it best to do the master details relationships at the table level or the view level?
Kim
Sergey Kornilov admin 8/20/2007

It doesn't really matter. Master-details relationships should work the same way for both.