Sub-form (master-detail form)
Posted: Fri Jan 26, 2007 9:57 pm
hi all,
I have a problem creating a "subform" in PHP. I use MySQL as my database.
what i want to create is a Sales Order form that submit data to database. It has Document No. as the master's Primary Key, and Document No. and Line No. as the child's Primary key.
For the illustration:
================================| Master
Document No : SO-0001 |
Order Date : 01/27/07 |
================================|Detail
Line No. | Item No. | Quantity |
======== |====== |================|
1 | OP-001 | 1,000 |
2 | OP-002 | 1,500 |
3 | OP-003 | 2,550 |
=================================
i hope you can help me solve my prob.. thx
I have a problem creating a "subform" in PHP. I use MySQL as my database.
what i want to create is a Sales Order form that submit data to database. It has Document No. as the master's Primary Key, and Document No. and Line No. as the child's Primary key.
For the illustration:
================================| Master
Document No : SO-0001 |
Order Date : 01/27/07 |
================================|Detail
Line No. | Item No. | Quantity |
======== |====== |================|
1 | OP-001 | 1,000 |
2 | OP-002 | 1,500 |
3 | OP-003 | 2,550 |
=================================
i hope you can help me solve my prob.. thx